10g to 9i database data migration

mathewb · Post by **mathewb** » Thu Aug 30, 2007 11:23 am

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

kris · Post by **kris** » Thu Aug 30, 2007 12:59 pm

See this post
http://dsxchange.com/viewtopic.php?t=10 ... 1d03938f59

bkumar103 · Post by **bkumar103** » Fri Aug 31, 2007 10:45 pm

I dont think 10G loader will be able to load data in 9i database. 9i loader can load the data in 10G. try using 9i loader. change the dsenv to point to 9i loader.

JoshGeorge · Post by **JoshGeorge** » Fri Aug 31, 2007 11:07 pm

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.

mathewb · Post by **mathewb** » Wed Sep 05, 2007 9:22 am

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

chulett · Post by **chulett** » Wed Sep 05, 2007 10:49 am

We support both 9i and 10g using a 9i client without issue.

gateleys · Post by **gateleys** » Wed Sep 05, 2007 11:20 am

chulett wrote:We support both 9i and 10g using a 9i client without issue.

Ditto!!!

chulett · Post by **chulett** » Wed Sep 05, 2007 12:32 pm

However, just now noticing the forum we're in, I'll add the caveat that in my specific case we are Server only. Not sure it matters, but wanted to make that point.

gateleys · Post by **gateleys** » Wed Sep 05, 2007 2:02 pm

chulett wrote:However, just now noticing the forum we're in, I'll add the caveat that in my specific case we are Server only. Not sure it matters, but wanted to make that point.

Uh-oh!! Ditto again.

mathewb · Post by **mathewb** » Thu Sep 06, 2007 12:13 pm

what is the 9i version...Is it 9.2.0.7 or is it 9.2.0.8?? ... We are having problem with java libs with the 9.2.0.7_64 client and 10g database.

chulett · Post by **chulett** » Thu Sep 06, 2007 12:47 pm

From what I recall, we're using 9.2.06 actually.

coface · Post by **coface** » Wed Oct 15, 2008 7:14 am

JoshGeorge 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.

Please check following thread for further details using 10g Client with 9i Server: viewtopic.php?t=121926&highlight=oracle+10g

DSXchange

10g to 9i database data migration

10g to 9i database data migration

Re: 10g to 9i database data migration