Home » RDBMS Server » Server Utilities » exp full=y do not want system user on imp full=y
exp full=y do not want system user on imp full=y [message #202651] Fri, 10 November 2006 12:40 Go to next message
TLegend33
Messages: 203
Registered: March 2005
Senior Member
I have an old 7.3.3 DB on an AIX 4.3 server. This db has about 90 users, not all of them have objects associated with them. I would like to exp full=y so I can grab all user definitions, as I do not have the original create scripts with passwords. Once I create the export on a Windows 2000 os with 7.3 installed, I'm going to import it to a server 2000 machine running oracle 8.1.7. I would like to import everything except for the SYSTEM users objects. Is this possible? Can I execute imp full=y, ignore the 'object already exists & integrity constraint errors', then have the rest of the import run, creating the users and their associated objects without an issue?

Thanks.
Re: exp full=y do not want system user on imp full=y [message #202652 is a reply to message #202651] Fri, 10 November 2006 12:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
just precreate the tablespaces.
If this i a fresh import (import into an empty database) then
why would you expect these errors?
>> 'object already exists & integrity constraint errors',
Re: exp full=y do not want system user on imp full=y [message #202653 is a reply to message #202652] Fri, 10 November 2006 12:47 Go to previous messageGo to next message
TLegend33
Messages: 203
Registered: March 2005
Senior Member
Yes, I had planned on pre-creating the tablespaces. It is a fresh import, but the system user will have been created with all it's associated objects. Wouldn't that generate errors on the import?
If I exp & imp as the system user that is....

Thanks.

[Updated on: Fri, 10 November 2006 12:48]

Report message to a moderator

Re: exp full=y do not want system user on imp full=y [message #202686 is a reply to message #202651] Fri, 10 November 2006 23:59 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

ignore the 'object already exists'

used ignore = y
creating the users
you have to create user manually.
through import operation it is not possible.

hope this helps.
Mohammad Taj.
Previous Topic: SQLLDR: Loading Ref Columns
Next Topic: Wrap Utility not working
Goto Forum:
  


Current Time: Sat Dec 10 06:54:16 CST 2016

Total time taken to generate the page: 0.09749 seconds