Re: Restores using Incrementals

It's not going to work.
This is because an incremental export exports the *complete* table if any change took place. It doesn't export the affected rows only. If you want to pursue this route further you should devise a mechanism to drop or truncate the affected tables in the target database before you start importing.
Using the sql*plus COPY command might be just as efficient.

Regards,

Sybrand Bakker, Oracle DBA

"mkb" <mkb125NOmkSPAM_at_yahoo.com.invalid> wrote in message news:06b8403a.b77f2489_at_usw-ex0104-031.remarq.com...
> Here's a scenario I'd like some comments on.
>
> I have a production database and need to sync it up using
> export/import.
>
> Day 1
> I do a full export from production and restore to test.
>
> Day 2
> I do an incremental from production, and restore using imp
> inctype=system followed by imp inctype=restore.
>
> Day 3
> To keep in sync repeat steps from Day 2...
>
> I assume that the test db can only be read-only since if
> anything changes, I'll need to retore the full export from Day 1
> and apply the incrementals.
>
> So, is this feasible, or will I have to restore the full exports
> each day?
>
> Thanks
>
> mkb
>
>
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Wed Jul 05 2000 - 00:00:00 CDT