Re: snapshot - might you mean, export?

Roy,

I'd consider an export with the parameter CONSISTENT=Y to be a "snapshot" suitable for representing a database at a point in time (ideally, that time is at a very low usage period). Usually, this is most useful when imported into a different database for the purpoase of extracting a particular set of tables, or for dropping and importing specific tables that *have suddenly dissappeared*. Sure, the Oracle snapshot is good for deploying against non-master DB's, but if the purpose if for archival of current data on your production instance that is east to get to, I"d say that the logical export complements the regulat hot/cold backup regime nicely.

Paul

Roy Ferguson wrote:

> having never done this before, I was hoping that someone would be able to help...
>
> I've been asked to take either a complete or partial snapshot of our production
> database every evening...
>
> information on how to do this is greatly appreciated...
>
> thanks in advance...roy
>
> --
> Author: Roy Ferguson
> INET: rferguso_at_level1.com
Received on Wed Sep 06 2000 - 01:17:22 CDT