Re: exp and archive available.... recover table

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Wed, 11 Jul 2007 15:22:39 -0700
Message-ID: <1184192559.820604.242460@q75g2000hsh.googlegroups.com>

On Jul 9, 10:05 am, Alexander Skwar <alexan..._at_skwar.name> wrote:
> fitzjarr..._at_cox.net <fitzjarr..._at_cox.net> wrote:
> > An export is a logical copy of the object or objects exported at the
> > time the object copy began. It is not a backup, even in the loosest
> > sense of the word.
>
> What makes this a "non backup"? You can use an EXP dump to recover
> all the data, can't you? You'll of course just need to create an
> "empty" database before you can run IMP.
>
> Alexander Skwar

Correct up to only the time the export was taken and not afterward with some possible consequences regarding consistent and version dependencies.

Create an empty database? Well often you just need a new dummy schema and can use the fromuser touser depending on size availability etc. Received on Wed Jul 11 2007 - 17:22:39 CDT