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

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 12 Jul 2007 20:35:29 +0200
Message-ID: <f75s9d$ha7$2@news6.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Alexander Skwar wrote:
> · sybrandb_at_hccnet.nl <sybrandb_at_hccnet.nl>:
>

>> On Wed, 11 Jul 2007 10:52:09 +0200, Alexander Skwar
>> <alexander_at_skwar.name> wrote:
>>
>>>> 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
>> Sorry to ask, but are you unable to read or are you just too stupid to
>> understand

>
> Neither. But can you also ask in a nice way, without trying to insult
> someone?
>

>> exp is essentially a series of INSERT statements, and NOT a 
>> *physical* backup (if you don't understand the difference between
>> 'physical'  and 'logical' please look up those words in a dictionary),
>> and you will *LOOSE* (I repeat L O O S E)  ALL (I repeat A L L)
>> Transactions made after your export?

>
> Of course you loose everything after the export. That's a given.
> But when you import an exp dump, you get everything back, that's
> in the exp dump, don't you? So, why is this not a backup?
>
> Alexander Skwar

Where would you import it into?

That is one major difference between backups and exports.

Backups can be restored, recovered and everything is hunky-dory. Exports (or any logical backup) must be read *into* something. What if that something is gone?

• -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGlnRxLw8L4IAs830RAlCcAJ9bOW2RpVsFk7Nc+eXyw8vnQRX2CgCdHTky lM38xEI5tla7I7DsNkFu4iM=
=K3SL
-----END PGP SIGNATURE----- Received on Thu Jul 12 2007 - 13:35:29 CDT