Re: oracle newbie: how do I backup?

Hi Sybrand,

thanks for the reply.
The reason I'm asking is the following: I need to 'copy' a database from one machine to another and vice versa. With Informix I did that by unloading/loading the database. The Informix unload, includes an sql script to create the database from scratch, including all indexes etc.

Does exp do the same for Oracle?

Henk

"Sybrand Bakker" <postmaster_at_sybrandb.demon.nl> schreef in bericht news:947542699.9863.0.pluto.d4ee154e_at_news.demon.nl...
> If you call unloading a database a backup, that's a logical backup, and
you
> should use exp (add the version number of Oracle for using this on NT, so
> exp80). This is however a binary file, and I know from other posts
Informix
> produces ascii files. In that case: you will have to write your own
scripts.
> I would use exp however.
> Please don't forget to make both logical and physical backups. With a
proper
> physical backup your recovery time will be minimal.
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
> Henk Wennink <wennink_at_gelrevision.nl> wrote in message
> news:85dhis$14kn$1_at_thor.wirehub.nl...
> > Hello,
> >
> > I'm a real Oracle newbie and have the following question: does Oracle
have
> > some tool or script to unload a database (structure and data)?
> > I have been working with Informix where this was no problem, but for
> Oracle
> > I haven't found thing like this.
> >
> > Thanks,
> >
> > Henk Wennink
> >
> >
>
>
Received on Tue Jan 11 2000 - 05:28:13 CST