RE: Import Urgent
- From: "Sinardy Xing" <SinardyXing@xxxxxxxxxxxxx>
- To: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
- Date: Thu, 2 Dec 2004 00:13:58 +0800
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@xxxxxxxxxxxxxxxxx]
Sent: Wednesday, December 01, 2004 11:39 PM
To: Sinardy Xing; Oracle-L@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx]=20
Sent: Wednesday, December 01, 2004 9:10 AM
To: Oracle-L@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
