Re: oracle newbie: how do I backup?

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 Mon Jan 10 2000 - 16:16:43 CST