RE: Import Urgent

thanks,

my problem is the users are not static, if the application add new = module new users will created.

this application is very complicated. everything are dynamic very = difficult to recover.

-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us] Sent: Wednesday, December 01, 2004 11:39 PM To: Sinardy Xing; Oracle-L_at_freelists.org Subject: RE: Import Urgent

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]=20 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,=3D20

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 =
   =3D
   step 4? I tried full=3D3Dy rows=3D3Dn constraints=3D3Dn indexes=3D3Dn (return =
   =3D
   irritating warning ora-00061)
4. import using fromuser touser

My objective is try to avoid error like ora-00061 =3D 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