Re: Oracle 9i transfer of data

On Wed, 30 Oct 2002 21:14:50 -0000, "mh579" <mh579_at_bluecarrots.com> wrote:

>Could you please help with the following query?
>
>Currently our databases are stand-alone Oracle 8, with data exported by
>table as a flat file on magnetic media. These flat files are then imported
>into another database using sqlloader etc.
>
>However we are upgrading to Oracle 9i and the systems will be networked
>together. The system will have unique ip addresses and computer names and
>unique database names.
>
>My question is, can the data from the required tables be "assembled" into an
>XML file and then sent to the recieving database and re-imported etc using
>Oracle queing etc. We are going the XML way, with the days change data for
>each database which is sent to a "master database" to form a global
>database.
>
>Thanks for any assistance.
>
>
>Martin
>

Why use XML, if you can insert directly using database links. IMO, this is just as cumbersome as your flat file communication.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Oct 30 2002 - 17:00:50 CST