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

Home -> Community -> Mailing Lists -> Oracle-L -> Import Urgent

Import Urgent

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Wed, 1 Dec 2004 22:10:01 +0800
Message-ID: <7534CC34CD1D9F49BB05A00B9C6F20F401852E44@antares.bcsgroup.com.sg>


Hi all,

How to import users only from full export,=20

here is the logic

  1. I have good full exported dump file
  2. drop all application users
  3. -----Question--- Can I use import to create user only before I go to = step 4? I tried full=3Dy rows=3Dn constraints=3Dn indexes=3Dn (return = irritating warning ora-00061)
  4. import using fromuser touser

My objective is try to avoid error like ora-00061 = system.Repcap$_object_null....
system primary key violation...

The log is too difficult to read for end user

Regards,
Sinardy

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 01 2004 - 08:09:25 CST

Original text of this message

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