Home » RDBMS Server » Server Utilities » load into oracle 7.3 (oracle xe,xp)
load into oracle 7.3 [message #406844] Sat, 06 June 2009 06:09 Go to next message
andi_raj
Messages: 55
Registered: February 2008
Member
Hi,
I want to export a table with data from oracle 10g and import into oracle 7.3. Is it possible?
raj kumar
Re: load into oracle 7.3 [message #406846 is a reply to message #406844] Sat, 06 June 2009 06:25 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
No.
Re: load into oracle 7.3 [message #406850 is a reply to message #406846] Sat, 06 June 2009 10:03 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Interested in workarounds?

As it is just a single ("export a table") table (which can be huge, though), you might create a CSV file as a simple SELECT * FROM this_table and load it into Oracle 7 using SQL*Loader.

Another option might be CTAS (or just INSERT INTO Ora_7_table SELECT * FROM Ora_10_table). I believe that it won't be possible directly as Oracle 7 and Oracle 10 don't see each other, so you'll need to use Oracle 9 in between. If I remember well, DB links might help a lot. Something like
          DB link            DB link
Oracle 7 <-------> Oracle 9 <-------> Oracle 10

SQL*Loader seems to be much simpler.
Previous Topic: SQL Loader problem in Oracle 10g
Next Topic: how to export statistics of table without table structure in oracle 9i
Goto Forum:
  


Current Time: Fri Dec 09 15:48:27 CST 2016

Total time taken to generate the page: 0.07736 seconds