Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How to EXPORT user Info?
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