OraFAQ Forum: Server Utilities » exp full=y do not want system user on imp full=y

Home » RDBMS Server » Server Utilities » exp full=y do not want system user on imp full=y

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

exp full=y do not want system user on imp full=y [message #202651]

Fri, 10 November 2006 12:40

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.

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
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',

Report message to a moderator

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

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

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.

Report message to a moderator

Previous Topic:	SQLLDR: Loading Ref Columns
Next Topic:	Wrap Utility not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 07:41:39 CDT 2024