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;