RE: Heavy data load at master site...

Possibly a better solution would be:

1. Break the refresh job on the snapshot site using dbms_job.broken(job#, 'Y')
2. Load data on the master site.
3. Unbreak the job at a convenient time or off hours using dbms_job.broken(job#, 'N') and allow the refresh to run normally from then on.

OR

1. Don't use a snapshot. Just run a job across the dblink to 'insert into local table select <whatever> from <remote table>@<remote site>;'

I have used both methods.

Scott Shafer
San Antonio, TX

> -----Original Message-----
> From: Ramamohan B N [SMTP:ramamohan.bn_at_tatainfotech.com]
> Sent: Friday, December 22, 2000 7:21 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Heavy data load at master site...
>
> Hi,
>
> I am having a Master Snapshot site setup. At the master site lot of old
> data has to be loaded. I dont want to clog my network with this data.
> Is there any way by which I can load the data at Master site first and
> then
> at the Snapshot site? (ie, these load should not be logged in the log
> tables)
>
> Also is it OK if I load some records at Master site and do not load it
> at all at the Snapshot site (provided this can be done)?
Received on Fri Dec 22 2000 - 08:54:32 CST