OraFAQ Forum: Backup & Recovery » Importing data from Oracle 9i to Oracle 7.3.4......

Home » RDBMS Server » Backup & Recovery » Importing data from Oracle 9i to Oracle 7.3.4......

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

Importing data from Oracle 9i to Oracle 7.3.4...... [message #208925]

Tue, 12 December 2006 11:01

tanya06
Messages: 4
Registered: December 2006
Location: INDIA

Junior Member

Hi,
We were working on Sun Solaries 2.6 with Oracle 7.3.4. The system got crashed. We had the latest dump. We import that dump into Oarcle 9i (Windows 2003 Platform). The system is working. Now our original system of Sun Solaries 8 with Oracle 7.3.4 is ready. Can we now import the dump of Oracle 9i to Oracle 7.3.4 ? We are unable to do that. What sholud we have to do to get backward compatibilty form Oracle 9i to Oracle 7.3.4.
Thanks.
D.J.B

Report message to a moderator

Re: Importing data from Oracle 9i to Oracle 7.3.4...... [message #208926 is a reply to message #208925]

Tue, 12 December 2006 11:06

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> We are unable to do that
What happened. Post the issues with error messages.
All you need to do is,
use the lower vesion of exp (oracle 7 exp) to export from 9i database and lower version on imp (oracle 7 imp ) to imp into 7x database.
if that does not work, you can recreate the 7x views related to exp/imp in a 9i database by running the catexp.sql of 7x version against the 9i database.

Report message to a moderator

Re: Importing data from Oracle 9i to Oracle 7.3.4...... [message #208933 is a reply to message #208926]

Tue, 12 December 2006 11:30

tanya06
Messages: 4
Registered: December 2006
Location: INDIA

Junior Member

Hi,
Thanks for the Prompt Reply. But how can I use the lower version (Oracle 7 exp) export / Import utilty ? Where will I get it ? I tried by copying the Imp.exe / Exp.exe of either versions. But that is not working.
And where will I get catexp.sql and how to use that ?

Thanks for the help.
D.J.B

Report message to a moderator

Re: Importing data from Oracle 9i to Oracle 7.3.4...... [message #208936 is a reply to message #208933]

Tue, 12 December 2006 11:35

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> But how can I use the lower version (Oracle 7 exp) export / Import utilty ?
Just use a tnsservicename ( an entry in tnsnames.ora)
For example,
here i am connecting from a 9i database to a remote 10g database

oracle@mutation#exp dbadmin/xxxx@10gdbtnsservice owner=dbadmin

Export: Release 9.2.0.7.0 - Production on Tue Dec 12 12:35:55 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)

>>where will I get catexp.sql and how to use that
First try above. If that does not work,
catexp.sql is found in $ORACLE_HOME/rdbms/admin.
run it against the database logged in as sys

Report message to a moderator

Re: Importing data from Oracle 9i to Oracle 7.3.4...... [message #208939 is a reply to message #208936]

Tue, 12 December 2006 11:44

tanya06
Messages: 4
Registered: December 2006
Location: INDIA

Junior Member

Hi,
Thanks for the help. We will try and let u know the result. If we still not able to convert from Oracle 9i to 7.3.4 then again will come back to this nice useful forum.

Thanks everybody.

D.J.B

Report message to a moderator

Re: Importing data from Oracle 9i to Oracle 7.3.4...... [message #209091 is a reply to message #208939]

Wed, 13 December 2006 04:49

tanya06
Messages: 4
Registered: December 2006
Location: INDIA

Junior Member

Hi,
But how to connect from 7.3 to 9i ?? I am not getting actually how to do that and from where we will run the command and actually what the command will be ??? Will it be in SQL> prompt or will it be on C:\ prompt. Kindly clarify.

Secondly you told me to use catexp.sql. I found that on c:\Oracle\ora92\rdbms\admin\catexp.sql. Is it ok ? Then I run the ecommand ---
SQL>@?/rdbms/admin/catexp

some long script has run and lots of message came as not found.

Kindly clarify as I am not able to undertstand and use both the options given by u.

Tahnks.
D.J.B

Report message to a moderator

Re: Importing data from Oracle 9i to Oracle 7.3.4...... [message #209106 is a reply to message #209091]

Wed, 13 December 2006 06:22

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> 7.3 to 9i ??
Add proper entries in tnsnames.ora. if your tnsentry is say ORACLE9iDB then
you can connect to it by
sqlplus user/passs@oracle9ib
Search the forum/google for more examples.
You should run the script logged in as SYS.
>> Kindly clarify as I am not able to undertstand and use both the options given by u.
Search the forum/google/docs.
first option is to use the lower version to export and import.
Second option is to install the higher version exp/imp views into a lower version database so that you can use the higher version utility against the lower version database (backward)

If all fails,talk to your DBA.

Report message to a moderator

Re: Importing data from Oracle 9i to Oracle 7.3.4...... [message #209108 is a reply to message #209091]

Wed, 13 December 2006 06:24

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Post deleted

[Updated on: Wed, 13 December 2006 06:25]

Report message to a moderator

Previous Topic:	How to recover the data if the DUMP file is also corrupted.
Next Topic:	Break of database restoring process

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 18:30:56 CST 2025