Home » SQL & PL/SQL » SQL & PL/SQL » what happens to dbms_scheduler.create_job's when import
what happens to dbms_scheduler.create_job's when import [message #250302] Mon, 09 July 2007 10:30 Go to next message
jsingh
Messages: 36
Registered: June 2007
Location: ny
Member
Hey Experts
I am working on 10.2.0.1
When I am importing a schema from one server to another . I get errors as following
*************************************************************
IMP-00017: following statement failed with ORACLE error 27486:

"BEGIN "

"dbms_scheduler.create_job('"USER_SNAPSHOT_JOB1"',"

"job_type=>'PLSQL_BLOCK', job_action=>"

"'periodic_active_user_count() ;'"

", number_of_arguments=>0,"

"start_date=>'30-AUG-06 02.00.26.011604 PM -05:00', Repeat_interval=> "

"'FREQ=MINUTELY;INTERVAL=15'"

", end_date=>NULL,"

"job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>TRUE,comments="

">"

"'Used to populate the subscribers snapshot table'"

");"

"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 USER_SNAPSHOT_JOB1. Remaining PL/SQL blocks for this object will be skipped.

IMP-00017: following statement failed with ORACLE error 27486:

"BEGIN "

"dbms_scheduler.create_job('"DO_HRLY_CH_VW_CNT_JOB"',"

"job_type=>'PLSQL_BLOCK', job_action=>"

"'begin"

" DO_HRLY_CH_VW_CNT( SYSDATE );"

"end;'"

", number_of_arguments=>0,"

"start_date=>'29-AUG-06 11.04.32.050532 AM -04:00', repeat_interval=> "

"'FREQ=HOURLY'"

", end_date=>NULL,"

"job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>FALSE,comments"

" =>"

"NULL"

");"
***********************************************************
So is it like the schedular jobs are not imported ??

Can somebody suggest some solutions to the above error.

Thanks in advance.

[Updated on: Mon, 09 July 2007 11:12]

Report message to a moderator

Re: what happens to dbms_scheduler.create_job's when import [message #250303 is a reply to message #250302] Mon, 09 July 2007 10:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and follow How to format your posts
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).

Does your imported user have directly (not via a role) the privilege to execute the procedures?

Regards
Michel
Re: what happens to dbms_scheduler.create_job's when import [message #250325 is a reply to message #250303] Mon, 09 July 2007 11:38 Go to previous messageGo to next message
jsingh
Messages: 36
Registered: June 2007
Location: ny
Member
Thanks Michel for replies

version:-10.2.0.1.0

I do not see any role granted to imported user (from role_role_privs, role_tab_privs )and also when i execute:--

SQL> select grantee,table_name,grantor,privilege from user_tab_privs_made where grantee='VMXLA_USER';

GRANTEE TABLE_NAME GRANTOR PRIVILEGE
------------------------------ ------------------------------ ------------------------------ ----------------------------------------
VMXLA_USER DATADIR1 SYS WRITE
VMXLA_USER DATADIR1 SYS READ

SQL> desc datadir1
ERROR:
ORA-04043: object datadir1 does not exist


But I can't describe datadir1(when I am conn as sys,VMXLA_user(imported user))

Regards



Re: what happens to dbms_scheduler.create_job's when import [message #250330 is a reply to message #250325] Mon, 09 July 2007 12:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Directory cannot be describe with "desc".

But the problem is not there.
Do you read my question?

Regards
Michel




Re: what happens to dbms_scheduler.create_job's when import [message #250341 is a reply to message #250330] Mon, 09 July 2007 12:55 Go to previous messageGo to next message
jsingh
Messages: 36
Registered: June 2007
Location: ny
Member
AS PER your ques:-/*Does your imported user have directly (not via a role) the privilege to execute the procedures?*/

I dont know if I am exactly looking at it or not ..
I am using role_role_privs,role_tab_privs,user_tab_privs_made,user_tab_privs_recd , ......from these views, I donot see any privilege to execute the procedures.....
I do'nt know if i am doing it right way or not..

Please Do suggest me how should i proceed.

Thanks
Re: what happens to dbms_scheduler.create_job's when import [message #250345 is a reply to message #250341] Mon, 09 July 2007 13:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I donot see any privilege to execute the procedures....

So you can't create a job to execute them and so the error in the import.
So all is clear.
Either you want it to execute the job and so the procedure and grant it the privilege.
Either you don't want it to execute the procedure and you can ignore the import error.

Regards
Michel
Re: what happens to dbms_scheduler.create_job's when import [message #250350 is a reply to message #250345] Mon, 09 July 2007 13:57 Go to previous message
jsingh
Messages: 36
Registered: June 2007
Location: ny
Member
Thanks Michel for your help

Regards

Previous Topic: LPAD in select
Next Topic: preserve whitespaces in xml
Goto Forum:
  


Current Time: Thu Dec 08 08:39:17 CST 2016

Total time taken to generate the page: 0.08921 seconds