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
Messages: 55
Registered: February 2008
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
Messages: 3186
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Re: load into oracle 7.3 [message #406850 is a reply to message #406846] Sat, 06 June 2009 10:03 Go to previous message
Messages: 20847
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: Thu Oct 27 09:52:13 CDT 2016

Total time taken to generate the page: 0.12650 seconds