oracle中，查询constraints ，查询procedure的调用

1. 查询 所有的constraints  :select * from dba_constraints where constraint_name = 'MCF_MODULE_UK'

2. 查询在那些package中调用了这个procedure: select * from all_source  where text like '%xxx%';

3.查询所有表的结构 ：select * from dba_tab_cols 

4.编译package后，查询是否错误：SELECT* FROM dba_objects WHERE status <> 'VALID' ；

5.启动job

  begin

dbms_scheduler.enable('NIFM_HOUSEKEEPING_JOB');
dbms_scheduler.enable('NIFM_FEED_PROCESS_JOB');
dbms_scheduler.enable('NIFM_FILE_PROCESS_JOB');
dbms_scheduler.enable('NIFM_FILE_DETECT_JOB');
end;