RE: Import and export question
- From: "Alec Macdonell" <amacdonell@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Apr 2004 11:57:45 -0700
This will be an ongoing means of data exchange. The client is using AIX
hardware while we are on Solaris. I believe this eliminates transportable
tablespaces as a viable option. (I certainly may be wrong on that :) )
Replication is not an option since we have not paid for it.
The client suggested this option as opposed to a data file feed. The data
being passed to us is workers comp injury records. On their system a worker
can have multiple injurys, an injury can have multiple physicians, and an
injury can have multiple ICD9 codes. Now the worker is not a problem since
one worker per injury can easily be sent in a file. The physicians and ICD9s
can be handle easily enough as well, however passing the table structures
back and forth seemed a decent solution.
I will set up a small table space with a few tables in it and experiment.
See how it goes :)
Jared,
Steve has been promoted to my Damager. He thought it was a 'neat' idea. :)
Alec
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Montgomerie Steve
Sent: Wednesday, April 21, 2004 10:59 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Import and export question
Is this a one shot deal or will you be exchanging information as a going
concern?
Steve Montgomerie
PeopleSoft/Oracle Administrator
SIEMENS Shared Services, LLC
4400 Alafaya Trail, M/S AL-222
Orlando, FL 32826
-----Original Message-----
From: Jared.Still@xxxxxxxxxxx [mailto:Jared.Still@xxxxxxxxxxx]
Sent: Wednesday, April 21, 2004 1:54 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: 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?
-------------
Hi Alec,
Just curious, why not just use the traditional method of applying a change
file.
One thing to remember is that if you start doing something like
replication, other
clients are going to find out about it, then they will want to do it as
well.
It could become rather unwieldy.
Jared
----------------------------------------------------------------
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
-----------------------------------------------------------------
-- Binary/unsupported file stripped by Ecartis --
-- Type: application/octet-stream
-- File: Montgomerie Steve.vcf
----------------------------------------------------------------
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:
