Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

RE: Import Urgent

From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
To: "'SinardyXing@xxxxxxxxxxxxx'" <SinardyXing@xxxxxxxxxxxxx>, Oracle-L@xxxxxxxxxxxxx
Date: Wed, 1 Dec 2004 10:39:18 -0500

Sinardy,

Create the users by hand before the import.  And then import the users
tables using fromuser/touser.  Should work fine.

Tom

-----Original Message-----
From: Sinardy Xing [mailto:SinardyXing@xxxxxxxxxxxxx] 
Sent: Wednesday, December 01, 2004 9:10 AM
To: Oracle-L@xxxxxxxxxxxxx
Subject: Import Urgent

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
--
http://www.freelists.org/webpage/oracle-l

RE: Import Urgent

Other related posts: