Import Urgent 2004-12-01 - By Sinardy Xing
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)]=20
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,=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 (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) =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
|
|
