Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Exporting a database (dmp file)
While you export the file it asks for OwnerName, and dmp file.
Create a parameter file,
add Owner name and dump file name in it.
For example:
file name: exp_20020412
userid=SCOTT/TIGER
file=exp_20020412.dmp
log=exp_20020412.log
buffer=1000000
owner=SCOTT
GRANTS=Y
Change the userid and password from SCOTT/ TIGER to your USERID/PASSWORD and
also change the OWNER from SCOTT to the USERID. That's all
Then give the following command.
exp parfile = exp_20020412
It should take care of it.
I use in the same way. If you still have trouble in that you can email me
padmaja_a_at_yahoo.com
Hope it will help you.
-Padmaja.
"JohnB" <barnesj_at_ci.mcminnville.or.us> wrote in message
news:uahakvsvt5mq45_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 Fri Apr 12 2002 - 16:25:05 CDT