Re: Automated Oracle DB Export?

Try running the imp/exp utility from a batch file. The syntax would lokk something like:

imp username/password@"SID" file=x:\oracle\admin\sid\exp\exp.dmp log=x:\oracle\admin\sid\exp\exp.log full=Y

This should all be on one line in the batch file.

Alternately, you have a batch file call a parameter file with the options to pass into the imp/exp utility. Try:
(this is the batch file)
IMP PARFILE=X:\ORACLE\ADMIN\"SID"\EXP\exp.par (this is the par file)
userid=username/password_at_sid
file=d:\oracle\admin\"SID"\exp\export.dmp log=d:\oracle\admin\"SID"\exp\exp.log
full=Y

<thedonger_at_my-deja.com> wrote in message news:959u4l$22d$1_at_nnrp1.deja.com...
> I'm new to Oracle, so bear with me please. Just converted from
> SQLAnywhere to Oracle for NT v 8.
>
> Is there a way to automate the Oracle DB dump for 8.x on NT?
>
> I usually do a dump by loading exp80 and exporting the entire database
> for backups. Very simple and you get all the goods.
>
> In Microsoft SQL 7, they make it real easy by having an automated
> maintenance function which includes database dumps. Just wondering if
> Oracle has a nifty automated way of doing the exp80 automatically every
> night at a specified time.
>
> Thanks,
> Keith
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Feb 01 2001 - 12:11:13 CST