my sync job doesn't work,why?
449371Aug 6 2005 — edited Aug 7 2005i use pl/sql create a sync job:
begin
sys.dbms_job.submit(job => :job,
what => 'BEGIN
ctx_ddl.sync_index(''MYDOC_INDEX'' );
END;
commit;',
next_date => to_date('06-08-2005 21:00:16', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'sysdate+1/96');
commit;
end;
but press "run",show errmessage box:
error running job:
ora-12011:don't run 1 job
ora-06512:at"sys.dbms_ijob",line 406
ora-06512:at"sys.dbms_job",line 272
ora-06512:at line 1
but i run:
BEGIN
ctx_ddl.sync_index('MYDOC_INDEX' );
END;
it work right,why?
anybody can help me?thanks~