Re: Help with Large Transfer between DBs

From: Tom Newton <thnewton_at_NOSPAMhotmail.com>
Date: Mon, 29 Jan 2001 23:31:41 GMT
Message-ID: <x3nd6.39734$ek.5448727@news02.optonline.net>

Mr Powell -

This was actually posted by my brother (using my machine)... here is his message...

" I want to respond to Mark Powell that the transfer will be about 1gb per day. Essentially, we will be appending 1GB to the destination db/tables each day.

Do you want torespond, or lend me your deja password..."

Just reply as though I'm him, he's reading it thru Deja. Thanks

Tom Newton (for Bob)

"Mark D Powell" <markp7832_at_my-deja.com> wrote in message news:951plh$4bt$1_at_nnrp1.deja.com...
> 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/
Received on Mon Jan 29 2001 - 17:31:41 CST