Home » RDBMS Server » Server Utilities » 10g-32bit,developer 6i
10g-32bit,developer 6i [message #562390] Wed, 01 August 2012 03:57 Go to next message
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.
Re: 10g-32bit,developer 6i [message #562392 is a reply to message #562390] Wed, 01 August 2012 04:02 Go to previous messageGo to next message
Michel Cadot
Messages: 67370
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: 10g-32bit,windows 2003 servers [message #562395 is a reply to message #562392] Wed, 01 August 2012 04:17 Go to previous messageGo to next message
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

Re: 10g-32bit,developer 6i [message #562433 is a reply to message #562390] Wed, 01 August 2012 07:54 Go to previous messageGo to next message
fantook
Messages: 3
Registered: July 2012
Location: lahore
Junior Member
I did not want to say about that, because all is know about 10g-32bit,developer 6i very well. I am very thankful for that...
Re: 10g-32bit,developer 6i [message #562437 is a reply to message #562433] Wed, 01 August 2012 07:57 Go to previous message
Michel Cadot
Messages: 67370
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Question
Previous Topic: calculated column population using sql loader
Next Topic: IMPORT(Impdp) multiple dump files
Goto Forum:
  


Current Time: Sun Sep 27 13:12:46 CDT 2020