10g to 9i database data migration
Moderators: chulett, rschirm, roy
10g to 9i database data migration
We need to extract data from a 10g database to a 9i database application. We created the datastage job and the write method is Load. Since the env file dsenv has path specified as 10g, the loader is failing after it loads the data. I am thinking the failure is becase the sqlloader is looking some 10g specific attributes while finishing with the load process.
The error is
Oracle_Enterprise_1,0: SQL*Loader-925: Error while uldlpim: OCIStmtExecute
Oracle_Enterprise_1,2: ORA-00904: "MESSAGE_NUM": invalid identifier
pls let me know what you guys think of this issue..
Thanks
mathew
The error is
Oracle_Enterprise_1,0: SQL*Loader-925: Error while uldlpim: OCIStmtExecute
Oracle_Enterprise_1,2: ORA-00904: "MESSAGE_NUM": invalid identifier
pls let me know what you guys think of this issue..
Thanks
mathew
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Try making Direct and Parallel options to false and run.
Below quote may be of interest for you
Below quote may be of interest for you
In Oracle 10g - 9i combination, when you try to load to 9i using 10g sqlldr it finally try to insert/update MESSAGE_NUM column which does not exist in 9i.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
The dsenv was changed to point to 10g since one project was migrating to 10g. We have now reverted back to 9i since we know that things will work with old setting. Now the work is to test all the 10G ones and find its problems.
Have you guys faced any problems for migrating database to 10G where as your DS still points to 9i path. Project level path will not help since these paths are appended to the existing one and will not take effect.
Thanks
mathewb
Have you guys faced any problems for migrating database to 10G where as your DS still points to 9i path. Project level path will not help since these paths are appended to the existing one and will not take effect.
Thanks
mathewb
Please check following thread for further details using 10g Client with 9i Server: viewtopic.php?t=121926&highlight=oracle+10gJoshGeorge wrote:Try making Direct and Parallel options to false and run.
Below quote may be of interest for you
In Oracle 10g - 9i combination, when you try to load to 9i using 10g sqlldr it finally try to insert/update MESSAGE_NUM column which does not exist in 9i.