Oracle Database PL/SQL Packages and Types Reference
http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_sched.htm#CIHHBGGI
Oracle Scheduler Chain 的用法(三)
，rule，由于存在依赖性，因此需要先删除job，然后可以删除chain，program等
scott@CNMMBO> EXEC DBMS_SCHEDULER.drop_chain (chain_name => 'test_chain_1');
BEGIN DBMS_SCHEDULER.drop_chain (chain_name => 'test_chain_1'); END;
*
ERROR at line 1:
ORA-27479: Cannot drop "SCOTT.TEST_CHAIN_1" because other objects depend on it
ORA-06512: at "SYS.DBMS_ISCHED", line 955
ORA-06512: at "SYS.DBMS_ISCHED", line 871
ORA-06512: at "SYS.DBMS_SCHEDULER", line 1446
ORA-06512: at line 1
EXEC DBMS_SCHEDULER.drop_job(job_name =>
'test_chain_1_job');
EXEC DBMS_SCHEDULER.drop_chain (chain_name => 'test_chain_1');
EXEC DBMS_SCHEDULER.drop_program (program_name => 'test_proc_1');
EXEC DBMS_SCHEDULER.drop_program (program_name => 'test_proc_2');
EXEC DBMS_SCHEDULER.drop_program (program_name => 'test_proc_3');
DROP TABLE tb_schduler;
DROP SEQUENCE tb_schduler_seq;