Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Exporting a database (dmp file)
This is one way to do it
exp file=filename.dmp owner="owner of database here"
then to imp
imp file=filename.dmp fromuser="owner of database here" touser="new owner of
database here"
"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 Mon Apr 01 2002 - 17:27:24 CST
![]() |
![]() |