Re: Snapshot

Julia,

Problem with snapshots is they incur the overhea of SQL*Net. Also, they are done as a single transaction with a commit at the end. You will need rollback segments larger than the table at the target database.

Why can't you just export the tables? Much faster. you can even do it over SQL*Net if you want to.

Andrew.

Julia Cristina Varela de Montoya wrote:
>
> Can anyone offer an opinion as to whether using a snapshot would be a
> viable way to backup a set of tables? We have a weekly batch process prior
> to which we'd like to afford our users the ability to backup the tables, in
> case something goes awry. We could then restore with scripts.
> The SQR (procedural code) to create the snapshot would drop and
> re-create it every time, ensuring fresh data, and that the snapshot table
> structure was identical to the master tables, in case they change. This
> would be the one and only time during it's life that it was refreshed (upon
> creation).
> Any potential problems someone could warn me a out?
>
> Thanks.
>
> Julia
Received on Wed Feb 17 1999 - 23:34:02 CST