Re: Oracle 9i data transfer

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Thu, 31 Oct 2002 14:11:14 GMT
Message-ID: <3DC13A02.6F25D68C@peasland.com>

> 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.

Just because you are upgrading to 9i does not mean that you have to change your processes. So your old method is still available to you.

> 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.

Have you looked at the Oracle XML tools available on Technet (http://technet.oracle.com)? They can help you load XML files directly into the database.

HTH,
Brian Received on Thu Oct 31 2002 - 08:11:14 CST