Home » RDBMS Server » Enterprise Manager » Error while creating a job from Oracle 9i EM
Error while creating a job from Oracle 9i EM [message #194146] Thu, 21 September 2006 00:06
Messages: 1
Registered: September 2006
Location: Bangalore
Junior Member
Hi All,

I am using oracle 9i, i am facing problem while scheduling a job through Enterprise Manager. My requirement is, i am having an index which i want to reindex for every 30 min.

The code that i placed inside the new job is "ctx_ddl.sync_index('PAGECONTENTS_INDEX');" but it is giving an error message of

ORA-23421: job number 2 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 526
ORA-06512: at "SYS.DBMS_JOB", line 169
ORA-06512: at line 1

Can any one please help me out.

Thanks in advance

Previous Topic: Not able to list in host after reinstalling Oracle10g grid
Next Topic: 10g Windows Grid Control change sysman pwd
Goto Forum:

Current Time: Mon Oct 24 02:19:37 CDT 2016

Total time taken to generate the page: 0.11981 seconds