RE: Import Urgent
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: 'Sinardy Xing' <SinardyXing@xxxxxxxxxxxxx>, Oracle-L@xxxxxxxxxxxxx
- Date: Wed, 1 Dec 2004 11:41:41 -0500
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@xxxxxxxxxxxxx]
Sent: Wednesday, December 01, 2004 11:14 AM
To: Mercadante, Thomas F; Oracle-L@xxxxxxxxxxxxx
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@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]
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:
