Re: Exporting a database (dmp file)

John,

For detailed options of exp check:

exp help=y

You have to create parameter file and then run the exp. Something like that:

userid=user/password
log=/dir/exp/exp_full.log
full=y
consistent=y
compress=n
direct=y
buffer=1000000
statistics=none

Save it as full_exp.par and run:

exp parfile=full_exp.par

Check the latest Oracle DBA forums for solutions to your problems: http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

Hope that helps,

Trifon Anguelov
Senior Oracle DBA

http://www.dbaclick.com

"JohnB" <barnesj_at_ci.mcminnville.or.us> wrote in message news:uahamb7d8iq761_at_corp.supernews.com...
> We are using Oracle v7.3.4 for Novell.
>
> How can I create a dmp file? Is it possible to do this with SQL Plus?
>
> John Barnes
> jbarnes_at_ci.mcminnville.or.us
>
>
>
Received on Mon Apr 01 2002 - 23:27:10 CST