Re: Automated Oracle DB Export?

Michael,

Thanks, that is exactly what I needed to know. A command line parameter to fill in the prompts...

Now I can just make my batch files for a nightly dump and schedule it.

Excellent!

Thanks,
Keith

In article <bDhe6.3785$d14.102405_at_news3.atl>,   "Michael Reeves" <mreeves_at_mreeves.net> wrote:
> 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/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Feb 01 2001 - 13:25:02 CST