RE: Import and export question
- From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Apr 2004 15:56:15 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Alec Macdonell
Sent: Tuesday, April 20, 2004 3:30 PM
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
