Re: Backing up Data in Oracle 9.2

On Sun, 27 Jul 2003 14:53:07 +0200, "Can Oezdemir" <no_at_spam.net> wrote:

>
>Errm, all I need is to rebuild the database after a new OS installation. And
>an export should be sufficient for this purpose, shouldn't it? Well, the
>manual says so at least (assuming I've understood it correctly). I've done a
>full export, but I guess an export on a user basis would have done it
>also....all the necessary tables werde saved in a binary format in
>"EXPDAT.DMP". And then I burnt it on a CD....why can't I speak of a backup
>then? Maybe I'm completely mistaken...would be kind if you gave me a hint,
>as to why this is not to be seen as a backup...

an export is an export is an export. It's purpose is a logical copy of a database to be imported into an *existing* database. The create database statement is not being exported. So if you don't have a target database to import into, you would need to create a database. Where do you get your create database staement from in you didn't save it beforehand. Also an export will consume much more resources, as an export is nothing more and nothing less than a series of inserts, one insert per record. Indexes are not being exported, only the create index statement is exported. Indexes will need to be recreated, consuming resources. With a backup you restore a physical copy of the database file and presto.
Do you still believe now an export is a backup? It isn't. An export is a logical copy.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Jul 27 2003 - 10:27:53 CDT