RE: Import Urgent

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Wed, 1 Dec 2004 10:39:18 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0702A970A8@exchsen0a1ma>

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_at_bkgcomsvc.com] Sent: Wednesday, December 01, 2004 9:10 AM To: Oracle-L_at_freelists.org
Subject: Import Urgent

Hi all,

How to import users only from full export,=20

here is the logic

I have good full exported dump file
drop all application users
-----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)
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 Received on Wed Dec 01 2004 - 10:01:35 CST