Home » RDBMS Server » Server Utilities » import 10g to 9i (Oracle 10g)  () 1 Vote
import 10g to 9i [message #415143] Sat, 25 July 2009 05:33 Go to next message
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.
Re: import 10g to 9i [message #415153 is a reply to message #415143] Sat, 25 July 2009 07:29 Go to previous messageGo to next message
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.
Re: import 10g to 9i [message #415177 is a reply to message #415153] Sat, 25 July 2009 15:54 Go to previous messageGo to next message
Littlefoot
Messages: 21823
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.
Re: import 10g to 9i [message #415178 is a reply to message #415177] Sat, 25 July 2009 15:57 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Absolutely, Littlefoot, I misread that one.

Thanks for catching that !!
Re: import 10g to 9i [message #417293 is a reply to message #415143] Fri, 07 August 2009 00:36 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21823
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.
Re: import 10g to 9i [message #417396 is a reply to message #417293] Fri, 07 August 2009 16:30 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
That is by design. If you check the 10g catexp.sql scripts it actually indicates the following:

Quote:
REM For 9.* the database links dont retrieve anything (1=2)
Re: import 10g to 9i [message #417493 is a reply to message #417396] Sun, 09 August 2009 21:52 Go to previous message
salman2k960
Messages: 12
Registered: September 2005
Junior Member
Thanx eBrain and littleFoot. i think i will have to use post import scripts to create db links and synonyms.
Previous Topic: Problem in loading data for clob columns
Next Topic: How To Import The .DMP File into The DataBase in Oracle9i
Goto Forum:
  


Current Time: Mon Dec 23 19:38:32 CST 2024