| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Import and export question
Here's the rule on export and import from/to different versions
of Oracle:
1) Export is done using the lower version exporter. In your
case, this would be 8.1.7; so you need an 8.1.7 client to do
the export for you against their 9i database.
2) The import is always done by an importer whose version is the same as the target database. In your case, againg this would be 8.1.7.
For an Oracle 9i database to support a version 8 exporter to export things, you may need the DBA to install the version 8 export views; the script is CATEXP8.SQL, or something along those lines, and is buried somewhere in RDBMS/Admin directory of the 9i server's binaries... hunt around for it.
...Rudy
-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On
Behalf Of Alec Macdonell
Sent: Tuesday, April 20, 2004 5:30 PM
To: oracle-l_at_freelists.org
Subject: Import and export question
We have a client that uses Oracle 9i. We are on 8.1.7. We need to =
exchange
eligibility information and transaction information between our two
companies. They are suggesting creating a user and a tablespace on each =
of
our platforms. We would then use imports and exports to move the data
between the two databases.
This seems like a fine solution but I would like input from anyone who =
may
have experience with a process like this. Are there any land mines that =
I am
not seeing?
Alec Macdonell
UsScript, Inc.
(559) 244-3736
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |