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

From: Alexander Skwar <alexander_at_skwar.name>
Date: Wed, 11 Jul 2007 10:52:09 +0200
Message-ID: <1386224.i6a6JejQd3@kn.gn.rtr.message-center.info>

fitzjarrell_at_cox.net <fitzjarrell_at_cox.net> wrote:

> On Jul 9, 9: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

>
> The inability to recover from a corrupt or lost/deleted data file. An
> export simply cannot recover tablespaces or datafiles, only objects
> within them, and only from the point in time when the object copy
> began.

Yes, that's of course right.

> Having to create a new database to restore data from an .dmp
> file proves that exp is not a backup.

Why is it not a backup? The recreated database contains then all the data which has been imported - and that is all the data that has been EXPorted at some certain time, isn't it?

Alexander Skwar Received on Wed Jul 11 2007 - 03:52:09 CDT