RE: Import Urgent
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'SinardyXing@xxxxxxxxxxxxx'" <SinardyXing@xxxxxxxxxxxxx>, Oracle-L@xxxxxxxxxxxxx
- Date: Wed, 1 Dec 2004 10:39:18 -0500
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]
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,=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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
