Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Exporting a database (dmp file)

Re: Exporting a database (dmp file)

From: mercilessming_2000 <rickl_2k1_nospam_at_yahoo.com>
Date: Mon, 01 Apr 2002 23:27:24 GMT
Message-ID: <w16q8.1574$XP2.420287@typhoon.southeast.rr.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US