| 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
I think FTPing export files is a workable method. We use this method to
send and receive data with a vendor since setting up remote synonyms and
direct querying would require a network connection. Since no secure network
connection exists we would have to open Oracle to the Internet to use any
feature that requires a db link. Opening access to any Oracle db directly
via the Internet is definitely not a secure method. So our filewall allows
files from a specific ip to write to a specific directory where the file is
picked up and transferred to another box where it is imported.
IMHO -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Alec Macdonell
Sent: Wednesday, April 21, 2004 2:58 PM
To: oracle-l_at_freelists.org
Subject: RE: Import and export question
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Montgomerie Steve
Sent: Wednesday, April 21, 2004 10:59 AM
To: 'oracle-l_at_freelists.org'
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_at_radisys.com [mailto:Jared.Still_at_radisys.com]
Sent: Wednesday, April 21, 2004 1:54 PM
To: oracle-l_at_freelists.org
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
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
 |
 |