Re: performance UTL Vs queues

Comments embedded

On 19 May 2003 10:53:20 -0700, nandagopalj_at_hotmail.com (Nan) wrote:

>Hello -
>
>I have 2 databases A and B on separate machines.
>I need to move data from A to B that have different schemas over the
>network.
>
>I have data from database-A in chunks of small files .
>Each file may contain data for as many of 50 tables.
>
>Would UTL files be considered a efficient way to read such large
>quantities of data files from pl/sql?

Definitely not

>I plan to read each of the file to process the data and then insert
>the results into different tables.
>
>Alternatively, how would it improve performance to use queues and set
>up the data as payloads ?

That would be a disaster solution.

Consider using database links and/or replication. It's there, why implement a primitive solution?

>
>Any input is appreciated..
>
>Thanks
>Jy.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon May 19 2003 - 16:23:57 CDT