Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Import and export question
Is there any chance you could set up replication instead? I would be
concerned with using imports and exports because there are a lot more
"moving parts" than with a replication-based solution. Your client, for
example, would need to ensure that they were using the 8.1.7 version of
the export utility to generate the file. They would have to script some
sort of file transfer process. You would have to script a file transfer
process. There would probably be ".lock" files involved so that you
weren't grabbing a file that they were delivering. You would then have
to script an import process. There are a lot of potential points for
problems to occur in this scenario. As one or both of you upgrade your
systems, there is the potential to break things.
If you are replicating the data, however, Oracle will take care of most of this.
If you were both on 9i, I would suggest transportable tablespaces as a possible solution as well.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----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 3: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
![]() |
![]() |