OraFAQ Forum: Server Utilities » export data from Oracle8i to 7.3

Home » RDBMS Server » Server Utilities » export data from Oracle8i to 7.3

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

export data from Oracle8i to 7.3 [message #74670]

Tue, 01 February 2005 23:30

D SINGH
Messages: 5
Registered: August 2004

Junior Member

Hi,
I have two databases one is oracle7.3 and another is oracle8i. Both are on diffrent locations and i cannot connect them..

Now I want to export the data from oracle8i and import into oracle7.3.

can anyone help to do this.

Thanks and Regds
D Singh

Report message to a moderator

Re: export data from Oracle8i to 7.3 [message #74690 is a reply to message #74670]

Thu, 03 February 2005 22:56

Sreedhar Reddy
Messages: 55
Registered: January 2002

Member

Either develope a front end tool or use an ETL tool which creates coma seperated flat files, and try using importing...the flat files

Report message to a moderator

Re: export data from Oracle8i to 7.3 [message #74710 is a reply to message #74670]

Mon, 07 February 2005 06:39

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

Senior Member
Account Moderator

method 1.
use the lower version to export and the same lower version to import.

to do this,
install 7.3 client in 8i machine.
take export of 8i database using 7.3 client.
make this file available in 7.3 machine.
use 7.3 import to import into 7.3 database.

method 2.
install the respective exp/imp views.
do the same.

Report message to a moderator

Previous Topic:	getting error ( ora-01031 ) while connecting to database
Next Topic:	Oreacle 8i to 9i upgrade-autocompile?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 19:53:54 CST 2024