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@(protected)]
Sent: Wednesday, December 01, 2004 11:14 AM
To: Mercadante, Thomas F; Oracle-L@(protected)
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@(protected)]
Sent: Wednesday, December 01, 2004 11:39 PM
To: Sinardy Xing; Oracle-L@(protected)
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@(protected)]
Sent: Wednesday, December 01, 2004 9:10 AM
To: Oracle-L@(protected)
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 (See ora-00061.ora-code.com))
4. import using fromuser touser
My objective is try to avoid error like ora-00061 (See ora-00061.ora-code.com) =
system.Repcap$_object_null....
system primary key violation...
