Re: how to make a snapshot of a whole database ? (all tables of a user)

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Thu, 7 Dec 2000 15:42:39 GMT
Message-ID: <3A2FAFEF.BE39B55F@edcmail.cr.usgs.gov>

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 - 09:42:39 CST