OraFAQ Forum: Server Utilities » Insufficient Privileges Error while importing

Home » RDBMS Server » Server Utilities » Insufficient Privileges Error while importing

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

Insufficient Privileges Error while importing [message #72260]

Sat, 26 April 2003 21:13

Rajah
Messages: 2
Registered: April 2003

Junior Member

I'm trying to import a *.dmp file from one schema to another on a different database server. The import of the tables kicks off fine but somewhere down the line I get the error message saying
"IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE TRIGGER "HRMXEMGR".trg_hrmx_insupddel_areas"
" BEFORE INSERT OR UPDATE OR DELETE ON t_hrmx_areas"
" FOR EACH ROW"
"""

and so on. The DBA told me that I was given sufficient privileges for Import but this is what happens. Please can you help.

Regards,
Rajah.

Report message to a moderator

Re: Insufficient Privileges Error while importing [message #72266 is a reply to message #72260]

Mon, 28 April 2003 06:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

If the schema owner is explicitly specified in the create trigger, then it May not be created properly
during the import.
I usually recreate the triggers after the import

Report message to a moderator

Re: Insufficient Privileges Error while importing [message #72267 is a reply to message #72266]

Mon, 28 April 2003 08:33

Rajah
Messages: 2
Registered: April 2003

Junior Member

Hi Mahesh,

Thanks for your time and help.
I have specified the schema owner only at the time of import and have not specified it explicitly anywhere else.

Thanks and Regards,
Rajah.

Report message to a moderator