| Export from 9i, import into 7? Any chance? [message #170249] |
Tue, 02 May 2006 19:38  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Original title:Will export from 9i with compatibilty set to 7.3.3 import into 7?
We will be experimenting to see if a 9i database running in 7.3.3.0.0 compatibility mode can produce an export file that can be imported into a real 7.3.3.0.0 database.
I am inquiring if anyone has every tried this before and whether they were successful.
I have read http://www.orafaq.com/forum/t/46450/0/ and the "Compatibility Matrix for Export & Import Between Different Oracle Versions" but I thought someone may have been able to trick it.
How about 9 -> 8 then 8 -> 7??
Okay - forget the compatibility mode, has anyway run the catexp7.sql in Oracle 9 and tried to run the Oracle 7 export utility against the 9i database? Did it work? Did it import into 7.3.3.0.0?
David
[Updated on: Tue, 02 May 2006 20:48] Report message to a moderator |
|
|
|
|
|
| Re: Export from 9i, import into 7? Any chance? [message #170254 is a reply to message #170253] |
Tue, 02 May 2006 21:25  |
|
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Thanks for your reply but the whole question has become moot.
We had a further look at this problem. Oracle doesn't HAVE an Oracle 7 that runs on the box on which we have Oracle 9 (32 vs 64 bit or 64 vs 128 bit or something like that). So we can't run the 7 export anyway.
David
[Updated on: Tue, 02 May 2006 21:25] Report message to a moderator |
|
|
|
| Re: Export from 9i, import into 7? Any chance? [message #170363 is a reply to message #170254] |
Wed, 03 May 2006 08:10 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Export and Import tools work based on a few simple views stored inside dictionary.
In many cases export/import bewteen Oracle X between Oracle Y can be done, provided the proper export/import views are installed (One may not want to do this production environment and in some cases You cannot directly export and import. Because several views are drastically changed between versions).
i have not tried between 9i and 7.3. I do not have a 7.3 media around. Else i would even give a try.
anacedent suggested:
>> From the V7.3.3 tree run "exp username/password@v90"
Which may also mean, oracle V90 is sitting in a different host.
The real cool (and the intended) functionality of Exp/Imp tools is the ability to dump data across
any OS and 32/64 OS bit. So 32 or 64 bit does not really matter.
Regards
EDIT:
Removed the irrelevent URL posted alongwith. (just copied from my Emacs buffer.)
[Updated on: Wed, 03 May 2006 08:19] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
