Home » RDBMS Server » Server Administration » Data Refresh between 8i and 11g (HP-UX,Oracle 11g,8i)
Data Refresh between 8i and 11g [message #548000] Mon, 19 March 2012 08:12 Go to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi Team,

The developer team wants to test their application.
For the same they need some data which resides at oracle 8i instance.
However they are not able to create a dblink between 11g and 8i as this is not supported by oracle.

Now they want the data to be refreshed from 8i to 11g by exp/imp.

Apart from exp and imp is there is any other alternatives?

Please suggest.

Thanks-
P
Re: Data Refresh between 8i and 11g [message #548001 is a reply to message #548000] Mon, 19 March 2012 08:14 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Spool the data you want to a csv file and load it with sqlloader.
Spool the data you want as insert statements to a file and load that way.
Re: Data Refresh between 8i and 11g [message #548025 is a reply to message #548001] Mon, 19 March 2012 12:44 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do you have, by any chance Oracle 9i database installed and accessible from both Oracle 8i and 11g? If so, try to create a database link from 8i to 9i, and then from 9i to 11g.

I'm not saying that it will work; if I remember well, we used that "trick" to connect 8i and 10g. Hopefully, it'll work for you too.
Previous Topic: not able to run setup.exe
Next Topic: Database users size
Goto Forum:
  


Current Time: Thu Mar 28 10:44:58 CDT 2024