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 -> How to EXPORT user Info?

How to EXPORT user Info?

From: levy <levy_at_netsgo.com>
Date: Wed, 8 Jul 1998 10:34:40 +0900
Message-ID: <dFRKsDhq9GA.208@news3.netsgo.com>


I exported just as this

$exp scott/tiger file=exp_file owner=scott

and deleted user scott

svrmgr> drop user scott cascade

Finally, I tried to import

$imp system/password file=exp_file.dmp fromuser=scott touser=scott

but it failed because there in no user scott.

How can I make it that the user scott is created when I import ? Received on Tue Jul 07 1998 - 20:34:40 CDT

Original text of this message

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