Re: Backing up Data in Oracle 9.2

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> schrieb im Newsbeitrag news:air7ivct7m08vurdmeh6t36ke47j917nlj_at_4ax.com...
> 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.
>

I see....thank you for clarifying this. So I gotta read on ;o) Thanks again,

Can Received on Sun Jul 27 2003 - 11:30:46 CDT