Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to make a snapshot of a whole database ? (all tables of a user)
What I mean with a snapshot is at a certain moment in time making a copy of
a consistent operational database with a minimal delay. This making of a
snapshot
I want to do from our application or via oracle itself without user
intervention.
So exp(ort) and imp(ort) seems not the solution for me.
Thanks for your reaction.
Martin.
Brian Peasland wrote:
> It depends on what you mean by "snapshot". The way that I'd handle this
> is to use the export utility to dump the entire schema (with the OWNER
> parameter). Then I'd import that schema into another schema.
>
> HTH,
> Brian
>
> Martin Terpstra wrote:
> >
> > hello,
> >
> > what is the easiest way to make a snapshot of all tables of a certain
> > oracle user ?
> > Do I have to make a snapshot for each individual table ?
> >
> > thanks,
> >
> > --
> > Martin Terpstra Alcatel CID
> > Sr. Software Design Engineer New IP Solutions Group
> > tel: +1 (1)408 586 1129 720 South Milpitas Blvd.
> > fax: +1 (1)408 586 7686 Milpitas, CA 95035 USA
> > mailto:Martin.Terpstra@ind.alcatel.com http://www.ind.alcatel.com
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
Received on Thu Dec 07 2000 - 10:42:34 CST