OraFAQ Forum: Server Utilities » Full Import without import users SYS and SYSTEM (Who do this??)

Home » RDBMS Server » Server Utilities » Full Import without import users SYS and SYSTEM (Who do this??)

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

Full Import without import users SYS and SYSTEM (Who do this??) [message #70957]

Mon, 19 August 2002 10:13

Hiran From Brazil
Messages: 1
Registered: August 2002

Junior Member

The whole times that I have to do a full import of a base any, first I create the base that had received the import full and later I begin import, and always of the error in the users that are already created (sys and system).
Somebody knows as doing an import full without taking the users sys and system.
(it is not worth the clause fromuser / to user)

Report message to a moderator

Re: Full Import without import users SYS and SYSTEM (Who do this??) [message #70964 is a reply to message #70957]

Tue, 20 August 2002 00:58

V Mohan
Messages: 3
Registered: August 2002

Junior Member

Create one user and give 'imp_full_database' grant to that user. So this user can do full import.

Report message to a moderator

Previous Topic:	TNS-00102
Next Topic:	SQL Loader -- Treating Invalid Date as NULL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 17:18:33 CDT 2024