RE: Import Urgent

Then I would, as a part of the export job, generate "create user" sql statements that go with each export that you could use when you need to re-import the tables. If it is needed, then you must create it! :)

-----Original Message-----

From: Sinardy Xing [mailto:SinardyXing_at_bkgcomsvc.com] Sent: Wednesday, December 01, 2004 11:14 AM To: Mercadante, Thomas F; Oracle-L_at_freelists.org Subject: 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] 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

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 Received on Wed Dec 01 2004 - 10:39:40 CST