Home » Developer & Programmer » Reports & Discoverer » Migration from Oracle Reports 6i to 10g (How to recompile the report query statement?)
icon5.gif  Migration from Oracle Reports 6i to 10g [message #274260] Mon, 15 October 2007 04:35 Go to next message
wolfie
Messages: 2
Registered: October 2007
Location: Israel
Junior Member
Hi.
In order to migrate my reports from 6i version to 10g (on linux) from the command line, i execute the following command:
rwconverter.sh userid=usr/passwd stype=RDFFILE source=myfile6i.rdf dtype=RDFFILE batch=yes dest=myfile10g.rdf overwrite=yes
This way doesn't recompile the query statement - only the program units of the report, and i have to do it, because several tables of our database were changed.
So, how can i make the rwconverter to recompile the query statement?
Thanks.

[Updated on: Mon, 15 October 2007 05:08]

Report message to a moderator

Re: Migration from Oracle Reports 6i to 10g [message #274294 is a reply to message #274260] Mon, 15 October 2007 07:35 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I believe you'll have to recompile the report manually (run Reports Builder, open a report, Compile All (<Ctrl> + <Shift> + K)).
Re: Migration from Oracle Reports 6i to 10g [message #274301 is a reply to message #274294] Mon, 15 October 2007 07:52 Go to previous message
wolfie
Messages: 2
Registered: October 2007
Location: Israel
Junior Member
This way doesn't work too. Only if you open the query, change it and undo the change (for example, put some space and remove it), the builder tries to recompile the query.
But i need it as a batch process in order to run on all the reports in the directory...
Previous Topic: Boilerplate text and hidden fields
Next Topic: whats wrong with the formula colomn
Goto Forum:
  


Current Time: Wed Dec 07 05:01:10 CST 2016

Total time taken to generate the page: 1.18759 seconds