Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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