Home » RDBMS Server » Server Utilities » importing data from Oralce9i to Oracle8i
importing data from Oralce9i to Oracle8i [message #8480] Mon, 25 August 2003 03:01 Go to next message
ARANGASWAMY.V.
Messages: 29
Registered: April 2002
Junior Member
I am not able to import in Oracle8i, the dmp file which has been export in Oracle9i.

Is there anyway to import the same. Kindly enlighten me. It is urgently required.

advance thanks

Aranga

Report message to a moderator

Re: importing data from Oralce9i to Oracle8i [message #8484 is a reply to message #8480] Mon, 25 August 2003 04:42 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Use the Export utility of your 8i database to export the 9i database. Shouldn't pose too much problems.

MHE

Report message to a moderator

Re: importing data from Oralce9i to Oracle8i [message #8489 is a reply to message #8484] Mon, 25 August 2003 06:15 Go to previous messageGo to next message
ARANGASWAMY.V.
Messages: 29
Registered: April 2002
Junior Member
Thanks for your quick response.

It says the header is not matching. It comes out of the import.

It is not only with a particular server.

I am not in a position to import data (dmp file) from Oracle 9i to Oracle8i using the export utility (giving the import command).

kindly enlighten me.

with warm regards,

V.Aranga

Report message to a moderator

Re: importing data from Oralce9i to Oracle8i [message #8520 is a reply to message #8489] Thu, 28 August 2003 00:50 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
I think you misunderstood me, you should use the 8i export utility to EXPORT from the 9i and use the 8i import utility for the import in the 8i database. Leave the 9i tools for what they are, don't use them!

MHE

Report message to a moderator

Re: importing data from Oralce9i to Oracle8i [message #8524 is a reply to message #8520] Thu, 28 August 2003 06:49 Go to previous messageGo to next message
ARANGASWAMY.V.
Messages: 29
Registered: April 2002
Junior Member
Thank you for the response.

How to use the 8i utility to export from the 9i.

Kindly enlighten me further.

ARANGA

Report message to a moderator

Re: importing data from Oralce9i to Oracle8i [message #8526 is a reply to message #8524] Thu, 28 August 2003 07:27 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
In the TNSNAMES.ORA file of the 8i client you're using, put an entry to the 9i database (e.g. "ORA9I").

Then you open your command prompt and perform the export using the expNN.exe of this (8i) client to perform the export of the 9i. You use the import impNN.exe to put the dump you created in the 8i database (make sure there's an entry for this database in your clients' TNSNAMES.ORA too)
In the names of the executables, NN stands for the version of exp/imp like '73' or '80' => exp73.exe ,exp80.exe,...but in you're case it might be just exp.exe or imp.exe, I don't have a 8i client here, so I can't verify).

If not clear on import/export, go to http://tahiti.oracle.com and read the docs there.

MHE

Report message to a moderator

Re: importing data from Oralce9i to Oracle8i [message #8550 is a reply to message #8526] Thu, 28 August 2003 16:36 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA
Senior Member
In Oracle 8.1.7, it is just exp.exe and imp.exe as you suspected.

Report message to a moderator

Re: importing data from Oralce9i to Oracle8i [message #8569 is a reply to message #8526] Mon, 01 September 2003 01:23 Go to previous message
ARANGASWAMY.V.
Messages: 29
Registered: April 2002
Junior Member
The link provided therein does not go. Kindly provide the correct link.
The situation is that in the Head office Oracle 8i (Version 8.1.5) is running on UNIX. There are 5 sub-offices at different locations. two of which are new, provided with Oracle 9i running on LINUX.
The Head office and the sub-offices are not inter connected.
The data are being transferred across only through floppy, DAT drive, etc.

I have gone through the scripts available on this site. There are scripts like CATexp7.sql, etc. Is there any such script for data transfer from Oracle 9i to the lower version of Oracle.

Kindly update me further.

V.ARANGA

Report message to a moderator

Previous Topic: SQL*LOADER wildcard infile
Next Topic: importing data from oracle9i to oracle8i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jun 26 13:10:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.