OraFAQ Forum: Server Utilities » How to import oracle9i dmp file into oracle8i

Home » RDBMS Server » Server Utilities » How to import oracle9i dmp file into oracle8i

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

How to import oracle9i dmp file into oracle8i [message #72759]

Wed, 15 October 2003 02:43

Yuvraj Thapa
Messages: 28
Registered: May 2001

Junior Member

Dear guru,
Pls. help me step by step on this matter.
I'v tried exp.exe of both version on both server but
couldnot import.
Pls help,
Thanks in adv.
Regards,
Yuvraj

Report message to a moderator

Re: How to import oracle9i dmp file into oracle8i [message #72763 is a reply to message #72759]

Wed, 15 October 2003 06:52

Thiru
Messages: 1089
Registered: May 2002

Senior Member

1. Run ORacle 8i exp against Oracle 9i database from ORACLE_HOME of 8i. IF you encounter any errors,run catexp.sql from Orale 8i ORACLE_HOME/rdbms/admin/ as sys@Oracle_9i_database using sqlplus
and then rerun the Oracle 8i exp against the 9i database.

2. Import the the 9i dump file into 8i database using 8i imp. Use appropriate NLS_LANG setting when importing,preferrably the same one you used when exporting.

3. Rerun ORacle 9i's catexp.sql against 9i database if you have run oracle 8i's catexp against the 9i database previously as mentioned in step 1.

-Thiru

Report message to a moderator

Re: How to import oracle9i dmp file into oracle8i [message #72770 is a reply to message #72763]

Thu, 16 October 2003 01:32

yuvraj
Messages: 6
Registered: January 2002

Junior Member

dear thiru,
many thanks for your reply. i'v tried this but the problem is that exp.exe or imp.exe of one version of oracle refused to run on another version. i'v two version on different server which is not connected.
early response pls.
thanks & regards,
Yuvraj

Report message to a moderator

Re: How to import oracle9i dmp file into oracle8i [message #72776 is a reply to message #72770]

Thu, 16 October 2003 08:11

Thiru
Messages: 1089
Registered: May 2002

Senior Member

Yuvraj,
I had no problem doing that on Unix. Besides,how are you executing the exp across the higher version..It should be something like

1. In 8i environment

export ORACLE_SID=8i_SID

i) Run 8i's catexp against 9i database

sqlplus sys/password@Oracle_9i_string @$ORACLE_HOME/rdbms/admin/catexp.sql

ii) Use 8i exp against 9i database

exp user/pass@Oracle_9i_connect_string owner=...

iii) Import into 8i database using 8i imp

imp user/pass file= fromuser= touser= ...

2. In 9i environment

export ORACLE_SID=9i_SID
i) Run 9i's catexp.sql against 9i database to restore the 9i dictionary views

sqlplus sys/password@9i_connect_string @$ORACLE_HOME/rdbms/admin/catexp.sql

-Thiru

Report message to a moderator

Re: How to import oracle9i dmp file into oracle8i [message #73322 is a reply to message #72776]

Wed, 24 March 2004 00:55

Esteban
Messages: 6
Registered: February 2003

Junior Member

People,

What if I don't have Oracle 9i and my partner wants to give me a dmp file? Should I be able to import the file without problems? What my partner's suppose to be aware of when creating the dmp file?

-Esteban

Report message to a moderator

Previous Topic:	ora-01122, ora-01110, ora-01207
Next Topic:	Export / Import fails with IMP-00058 and ORA-00604

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 20:26:19 CST 2024