OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » import 10g to 9i (Oracle 10g) (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import 10g to 9i [message #415143]

Sat, 25 July 2009 05:33

snsiddiqui
Messages: 172
Registered: December 2008

Senior Member

dear all

I want to import oracle10g 10.1.0.2.0 data into oracle9i, is there any special instructions or steps? which I should follow.

Report message to a moderator

Re: import 10g to 9i [message #415153 is a reply to message #415143]

Sat, 25 July 2009 07:29

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Export from 9i using the 9i exp utility and import into 10g using the 10g imp utility.

Report message to a moderator

Re: import 10g to 9i [message #415177 is a reply to message #415153]

Sat, 25 July 2009 15:54

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Hm, did you misread the question, Brian? He wants to import 10g into 9i (so none of 10g utilities should be involved). Or am I wrong?

Therefore:
- export 10g database with 9i's export utility
- import data into 9i database with 9i's import utility.

Basically:
- export data using lower database's export utility.
- import data using target database's import utility.

Report message to a moderator

Re: import 10g to 9i [message #415178 is a reply to message #415177]

Sat, 25 July 2009 15:57

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Absolutely, Littlefoot, I misread that one.

Thanks for catching that !!

Report message to a moderator

Re: import 10g to 9i [message #417293 is a reply to message #415143]

Fri, 07 August 2009 00:36

salman2k960
Messages: 12
Registered: September 2005

Junior Member

LittleFoot:
i have googled alot about exporting 10g into 9i. even oracle says that one should use 9i export and 9i import. But to my disappointment, im loosing information in the process. so far, i have figured out that users's private DATABASE LINK as well as synonyms (at least to a remote package ) are missing. they are not loaded. if i inspect the DMP files using microsoft wordpad, i find that 9i database exported using 9i export utility contains DDL for databse link and synonyms. But if same schema existing in 10g database is exported using 9i export utility, the said DDLs are missing. Is there any special parameter of exp v9i that i should issue to export Database links and synonyms?
Hope to get an answer.
Regards

[Updated on: Fri, 07 August 2009 00:38]

Report message to a moderator

Re: import 10g to 9i [message #417325 is a reply to message #417293]

Fri, 07 August 2009 04:18

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Unfortunately, I'm not that experienced user and I wouldn't know the exact answer; I guess that someone else (such as Mahesh, Michel, Brian, etc.) might help.

Though: perhaps it is because lower (9i in your case) export utility doesn't know of "advanced" (i.e. from the higher database version, 10g in your case) export/import views used by these utilities. So, maybe 9i export didn't "find" your private database links and synonyms. Did you check 9i export's log file? Does it contain objects you have mentioned?

Perhaps you could read more about catalog.sql, catproc.sql and catexp.sql, how they are used and should they be used.

Sorry for not being able to help.

Report message to a moderator