Xref: alice comp.databases.oracle.misc:17311
From: "levy" <levy@netsgo.com>
Subject: How to EXPORT user Info?
Date: Wed, 8 Jul 1998 10:34:40 +0900
Lines: 20
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <dFRKsDhq9GA.208@news3.netsgo.com>
Newsgroups: comp.databases.oracle.misc
Path: alice!news-feed.fnsi.net!newsfeed1.earthlink.net!xfer.kren.ne.kr!xfer.kren.nm.kr!news-xfer.nuri.net!newsfeed.netsgo.com!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 ?



