Re: Help with Large Transfer between DBs

In article <M_Oc6.24188$ek.3627478_at_news02.optonline.net>,   "Tom Newton" <thnewton_at_NOSPAMhotmail.com> wrote:
> Does anyone know the best way to efficiently transfer a large number
 of rows
> (up to 1million rows) intra-day from several tables in one Oracle 8
 database
> to another? Are there any special utilities or methods? This needs to
> happen without any downtime on either side. Solaris environment.
>
> Many Thanks
>
> ------------------------
>
> bobnewtweb
>

The best way to move data between the two instances depends on several factors not specified in your post:

SQL directly selecting or inserting the data accross a database link is one way. Using snapshots, which basically perform this same task is another approach you can take.

Moving large quantities of data can generate a lot of redo and rollback.  The need to specifiy the use of a specific large rollback segment to support the operation and the option of using nologging operations as in a 'create table as select' need to be factored in. Megabytes are generally a better indicator of size and performance impact than number of rows.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com
http://www.deja.com/