| load into oracle 7.3 [message #406844] |
Sat, 06 June 2009 06:09  |
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 #406850 is a reply to message #406846] |
Sat, 06 June 2009 10:03  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
