OraFAQ Forum: Server Utilities » 10g-32bit,developer 6i

Home » RDBMS Server » Server Utilities » 10g-32bit,developer 6i

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

10g-32bit,developer 6i [message #562390]

Wed, 01 August 2012 03:57

sam524
Messages: 77
Registered: July 2012
Location: sydney

Member

hi guys can u please help me out.....

iam importing my dump file to new user iam getting following error how should i rectify my error please

IMP-00017: following statement failed with ORACLE error 27486:
"BEGIN "
"dbms_scheduler.create_job('"BCI_FORCASTED_SO_UPDATE"',"
"job_type=>'STORED_PROCEDURE', job_action=>"
", number_of_arguments=>0,"
"start_date=>TO_TIMESTAMP_TZ('22-MAY-2012 xx.xx.xx.xxxxx PM ASIA/JAPAN'"
",'DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_inte"
"rval=> "
"'FREQ=HOURLY;INTERVAL=12'"
", end_date=>NULL,"
"job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>FALSE,comments"
"=>"
"NULL"
");"
"dbms_scheduler.set_attribute('"BCI_FORCASTED_SO_UPDATE"','job_priority',2);"
"dbms_scheduler.enable('"BCI_FORCASTED_SO_UPDATE"');"
"COMMIT; END;"
IMP-00003: ORACLE error 27486 encountered
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 99
ORA-06512: at "SYS.DBMS_SCHEDULER", line 262
ORA-06512: at line 2
IMP-00091: Above error occurred on the following function and object: CREATE BCI_FORCASTED_SO_UPDATE. Remaining PL/SQL blocks for this object will be skipped.
About to enable constraints...
Import terminated successfully with warnings.

Report message to a moderator

Re: 10g-32bit,developer 6i [message #562392 is a reply to message #562390]

Wed, 01 August 2012 04:02

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

ORA-27486: insufficient privileges

Your (new) user has not the privilege to create a job.
If this is mandatory for it, give it the CREATE JOB privilege, if not then you can ignore the error.

Regards
Michel

Report message to a moderator

Re: 10g-32bit,windows 2003 servers [message #562395 is a reply to message #562392]

Wed, 01 August 2012 04:17

sam524
Messages: 77
Registered: July 2012
Location: sydney

Member

ok thank you very much michel cadot.......
what i do means i will give create job previleges and do import again....

hope will be fine....

thank you so much again for quick responding
regards,
Sam

[Updated on: Wed, 01 August 2012 04:19]

Report message to a moderator