IMP-00041: Warning: object created with compilation warnings昨天导入数据的时候，最后报错IMP-00041: Warning: object created with compilation warnings "CREATE TRIGGER "KFPT2".SYN_khgl_qyjbxx_D after delete on khgl_qyjbxx for e" "ach row declare num int; p_id syn_control_send_sql.id%type;begin " " select count(1) into num from syn_control_receive_sql s where (upper(s.ta" "ble_name)='khgl_qyjbxx') and (s.condition_clause='(NSRSBH='''||:OLD.NSRSBH|" "|''')') and s.handle_flag='0'; if(num=0)then select seq_syn_control_i" "d.nextval into p_id from dual; insert into syn_control_send_sql(id,t" "able_name,action_type,condition_clause,sql_clause,fzjg_dm,update_clob_field" "s,update_blob_fields,update_date,syn_flag) values(p_id,'khgl_qyjbxx','" "DELETE','(NSRSBH='''||:OLD.NSRSBH||''')','delete from khgl_qyjbxx where (NS" "RSBH='''||:OLD.NSRSBH||''')',''||replace(:OLD.FZJG_DM,'''','''''')||'','','" "',sysdate,'0'); end if; end SYN_khgl_qyjbxx_D;"IMP-00041: Warning: object created with compilation warnings "CREATE TRIGGER "KFPT2".SYN_khgl_qyjbxx_U after update on khgl_qyjbxx for e" "ach row declare num int; p_id syn_control_send_sql.id%type; p_sql_cla" "use varchar2(4000); p_update_clob_fields syn_control_send_sql.update_clob_" "fields%type; p_update_blob_fields syn_control_send_sql.update_blob_fields%" "type;begin select count(1) into num from syn_control_receive_sql s w" "here (upper(s.table_name)='khgl_qyjbxx') and (s.condition_clause='(NSRSBH='" "''||:NEW.NSRSBH||''')') and s.handle_flag='0'; if(num=0)then if(nvl(:NEW." "LWNSRSBH,'-12345')!=nvl(:OLD.LWNSRSBH,'-12345')) then if(p_sql_clause is" " null)then p_sql_clause:='update khgl_qyjbxx set LWNSRSBH='''||replace(" ":NEW.LWNSRSBH,'''','''''')||''''; else p_sql_clause:=p_sql_clause||'" ",LWNSRSBH='''||replace(:NEW.LWNSRSBH,'''','''''')||''''; end if; end if" "; if(nvl(:NEW.NSRSBH,'-12345')!=nvl(:OLD.NSRSBH,'-12345')) then if(p_s" "ql_clause is null)then p_sql_clause:='update khgl_qyjbxx set NSRSBH='''" "||replace(:NEW.NSRSBH,'''','''''')||''''; else p_sql_clause:=p_sql_c" "lause||',NSRSBH='''||replace(:NEW.NSRSBH,'''','''''')||''''; end if; en" "d if; if(nvl(:NEW.NSRMC,'-12345')!=nvl(:OLD.NSRMC,'-12345')) then if(p" "_sql_clause is null)then p_sql_clause:='update khgl_qyjbxx set NSRMC=''" "'||replace(:NEW.NSRMC,'''','''''')||''''; else p_sql_clause:=p_sql_c" "lause||',NSRMC='''||replace(:NEW.NSRMC,'''','''''')||''''; end if; end " "if; if(nvl(:NEW.NSRBM,'-12345')!=nvl(:OLD.NSRBM,'-12345')) then if(p_s" "ql_clause is null)then p_sql_clause:='update khgl_qyjbxx set NSRBM='''|" "|replace(:NEW.NSRBM,'''','''''')||''''; else p_sql_clause:=p_sql_cla" "use||',NSRBM='''||replace(:NEW.NSRBM,'''','''''')||''''; end if; end if" "; if(nvl(:NEW.SWJG_DM,'-12345')!=nvl(:OLD.SWJG_DM,'-12345')) then if(p" "_sql_clause is null)then p_sql_clause:='update khgl_qyjbxx set SWJG_DM=" "'''||replace(:NEW.SWJG_DM,'''','''''')||''''; else p_sql_clause:=p_s" "ql_clause||',SWJG_DM='''||replace(:NEW.SWJG_DM,'''','''''')||''''; end if" "; end if; if(nvl(:NEW.ZCBM,'-12345')!=nvl(:OLD.ZCBM,'-12345')) then " "if(p_sql_clause is null)then p_sql_clause:='update khgl_qyjbxx set ZCBM" "='''||replace(:NEW.ZCBM,'''','''''')||''''; else p_sql_clause:=p_sql" "_clause||',ZCBM='''||replace(:NEW.ZCBM,'''','''''')||''''; end if; end " "if; if(nvl(:NEW.NSRLB_DM,'-12345')!=nvl(:OLD.NSRLB_DM,'-12345')) then " "if(p_sql_clause is null)then p_sql_clause:='update khgl_qyjbxx set NSRL" "B_DM='''||replace(:NEW.NSRLB_DM,'''','''''')||''''; else p_sql_claus" "e:=p_sql_clause||',NSRLB_DM='''||replace(:NEW.NSRLB_DM,'''','''''')||''''; " " end if; end if; if(nvl(:NEW.DHHM,'-12345')!=nvl(:OLD.DHHM,'-12345')) " "then if(p_sql_clause is null)then p_sql_clause:='update khgl_qyjbxx " "set DHHM='''||replace(:NEW.DHHM,'''','''''')||''''; else p_sql_claus" "e:=p_sql_clause||',DHHM='''||replace(:NEW.DHHM,'''','''''')||''''; end if" "; end if; if(nvl(:NEW.JYDZ,'-12345')!=nvl(:OLD.JYDZ,'-12345')) then " "if(p_sql_clause is null)then p_sql_clause:='update khgl_qyjbxx set JYDZ" "='''||replace(:NEW.JYDZ,'''','''''')||''''; else p_sql_clause:=p_sql" "_clause||',JYDZ='''||replace(:NEW.JYDZ,'''','''''')||''''; end if; end " "if; if(nvl(:NEW.ZCDZ,'-12345')!=nvl(:OLD.ZCDZ,'-12345')) then if(p_sql" "_clause is null)then p_sql_clause:='update khgl_qyjbxx set ZCDZ='''||re" "place(:NEW.ZCDZ,'''','''''')||''''; else p_sql_clause:=p_sql_clause|" "|',ZCDZ='''||replace(:NEW.ZCDZ,'''','''''')||''''; end if; end if; if" "(nvl(:NEW.LXRMC,'-12345')!=nvl(:OLD.LXRMC,'-12345')) then if(p_sql_claus" "e is null)then p_sql_clause:='update khgl_qyjbxx set LXRMC='''||replace" "(:NEW.LXRMC,'''','''''')||''''; else p_sql_clause:=p_sql_clause||',L" "XRMC='''||replace(:NEW.LXRMC,'''','''''')||''''; end if; end if; if(n" "vl(:NEW.LXRSJ,'-12345')!=nvl(:OLD.LXRSJ,'-12345')) then if(p_sql_clause " "is null)then p_sql_clause:='update khgl_qyjbxx set LXRSJ='''||replace(:" "NEW.LXRSJ,'''','''''')||''''; else p_sql_clause:=p_sql_clause||',LXR" "SJ='''||replace(:NEW.LXRSJ,'''','''''')||''''; end if; end if; if(nvl" "(:NEW.XZQH_DM,'-12345')!=nvl(:OLD.XZQH_DM,'-12345')) then if(p_sql_claus" "e is null)then p_sql_clause:='update khgl_qyjbxx set XZQH_DM='''||repla" "ce(:NEW.XZQH_DM,'''','''''')||''''; else p_sql_clause:=p_sql_clause|" "|',XZQH_DM='''||replace(:NEW.XZQH_DM,'''','''''')||''''; end if; end if" "; if(nvl(:NEW.KHYHMC,'-12345')!=nvl(:OLD.KHYHMC,'-12345')) then if(p_s" "ql_clause is null)then p_sql_clause:='update khgl_qyjbxx set KHYHMC='''" "||replace(:NEW.KHYHMC,'''','''''')||''''; else p_sql_clause:=p_sql_c" "lause||',KHYHMC='''||replace(:NEW.KHYHMC,'''','''''')||''''; end if; en" "d if; if(nvl(:NEW.KHYHZH,'-12345')!=nvl(:OLD.KHYHZH,'-12345')) then if" "(p_sql_clause is null)then p_sql_clause:='update khgl_qyjbxx set KHYHZH" "='''||replace(:NEW.KHYHZH,'''','''''')||''''; else p_sql_clause:=p_s" "ql_clause||',KHYHZH='''||replace(:NEW.KHYHZH,'''','''''')||''''; end if; " " end if; if(nvl(:NEW.KPDZ,'-12345')!=nvl(:OLD.KPDZ,'-12345')) then if" "(p_sql_clause is null)then p_sql_clause:='update khgl_qyjbxx set KPDZ='" "''||replace(:NEW.KPDZ,'''','''''')||''''; else p_sql_clause:=p_sql_c" "lause||',KPDZ='''||replace(:NEW.KPDZ,'''','''''')||''''; end if; end if" "; if(nvl(:NEW.YZBM,'-12345')!=nvl(:OLD.YZBM,'-12345')) then if(p_sql_c" "lause is null)then p_sql_clause:='update khgl_qyjbxx set YZBM='''||repl" "ace(:NEW.YZBM,'''','''''')||''''; else p_sql_clause:=p_sql_clause||'" ",YZBM='''||replace(:NEW.YZBM,'''','''''')||''''; end if; end if; if(n" "vl(:NEW.EMAIL,'-12345')!=nvl(:OLD.EMAIL,'-12345')) then if(p_sql_clause " "is null)then p_sql_clause:='update khgl_qyjbxx set EMAIL='''||replace(:" "NEW.EMAIL,'''','''''')||''''; else p_sql_clause:=p_sql_clause||',EMA" "IL='''||replace(:NEW.EMAIL,'''','''''')||''''; end if; end if; if(nvl" "(:NEW.JTLX,'-12345')!=nvl(:OLD.JTLX,'-12345')) then if(p_sql_clause is n" "ull)then p_sql_clause:='update khgl_qyjbxx set JTLX='''||replace(:NEW.J" "TLX,'''','''''')||''''; else p_sql_clause:=p_sql_clause||',JTLX='''|" "|replace(:NEW.JTLX,'''','''''')||''''; end if; end if; if(nvl(:NEW.CZ" "HM,'-12345')!=nvl(:OLD.CZHM,'-12345')) then if(p_sql_clause is null)then" " p_sql_clause:='update khgl_qyjbxx set CZHM='''||replace(:NEW.CZHM,''''" ",'''''')||''''; else p_sql_clause:=p_sql_clause||',CZHM='''||replace" "(:NEW.CZHM,'''','''''')||''''; end if; end if; if(nvl(:NEW.MSN,'-1234" "5')!=nvl(:OLD.MSN,'-12345')) then if(p_sql_clause is null)then p_sql" "_clause:='update khgl_qyjbxx set MSN='''||replace(:NEW.MSN,'''','''''')||''" "''; else p_sql_clause:=p_sql_clause||',MSN='''||replace(:NEW.MSN,'''" "','''''')||''''; end if; end if; if(nvl(:NEW.QQ,'-12345')!=nvl(:OLD.Q" "Q,'-12345')) then if(p_sql_clause is null)then p_sql_clause:='update" " khgl_qyjbxx set QQ='''||replace(:NEW.QQ,'''','''''')||''''; else p_" "sql_clause:=p_sql_clause||',QQ='''||replace(:NEW.QQ,'''','''''')||''''; e" "nd if; end if; if(nvl(:NEW.ZGYMC,'-12345')!=nvl(:OLD.ZGYMC,'-12345')) t" "hen if(p_sql_clause is null)then p_sql_clause:='update khgl_qyjbxx s" "et ZGYMC='''||replace(:NEW.ZGYMC,'''','''''')||''''; else p_sql_clau" "se:=p_sql_clause||',ZGYMC='''||replace(:NEW.ZGYMC,'''','''''')||''''; end" " if; end if; if(nvl(:NEW.SWFS_DM,'-12345')!=nvl(:OLD.SWFS_DM,'-12345'))" " then if(p_sql_clause is null)then p_sql_clause:='update khgl_qyjbxx" " set SWFS_DM='''||replace(:NEW.SWFS_DM,'''','''''')||''''; else p_sq" "l_clause:=p_sql_clause||',SWFS_DM='''||replace(:NEW.SWFS_DM,'''','''''')||'" "'''; end if; end if; if(nvl(:NEW.OS,'-12345')!=nvl(:OLD.OS,'-12345'))" " then if(p_sql_clause is null)then p_sql_clause:='update khgl_qyjbxx" " set OS='''||replace(:NEW.OS,'''','''''')||''''; else p_sql_clause:=" "p_sql_clause||',OS='''||replace(:NEW.OS,'''','''''')||''''; end if; end" " if; if(nvl(:NEW.DYJLX_DM,'-12345')!=nvl(:OLD.DYJLX_DM,'-12345')) then " " if(p_sql_clause is null)then p_sql_clause:='update khgl_qyjbxx set DYJ" "LX_DM='''||replace(:NEW.DYJLX_DM,'''','''''')||''''; else p_sql_clau" "se:=p_sql_clause||',DYJLX_DM='''||replace(:NEW.DYJLX_DM,'''','''''')||'''';" " end if; end if; if(nvl(:NEW.SMYXH,'-12345')!=nvl(:OLD.SMYXH,'-12345'" ")) then if(p_sql_clause is null)then p_sql_clause:='update khgl_qyjb" "xx set SMYXH='''||replace(:NEW.SMYXH,'''','''''')||''''; else p_sql_" "clause:=p_sql_clause||',SMYXH='''||replace(:NEW.SMYXH,'''','''''')||''''; " " end if; end if; if(nvl(:NEW.ISDLQY,'-12345')!=nvl(:OLD.ISDLQY,'-12345'" ")) then if(p_sql_clause is null)then p_sql_clause:='update khgl_qyjb" "xx set ISDLQY='''||replace(:NEW.ISDLQY,'''','''''')||''''; else p_sq" "l_clause:=p_sql_clause||',ISDLQY='''||replace(:NEW.ISDLQY,'''','''''')||'''" "'; end if; end if; if(nvl(:NEW.FZJG_DM,'-12345')!=nvl(:OLD.FZJG_DM,'-" "12345')) then if(p_sql_clause is null)then p_sql_clause:='update khg" "l_qyjbxx set FZJG_DM='''||replace(:NEW.FZJG_DM,'''','''''')||''''; else " " p_sql_clause:=p_sql_clause||',FZJG_DM='''||replace(:NEW.FZJG_DM,'''',''" "'''')||''''; end if; end if; if(nvl(:NEW.LRR_DM,'-12345')!=nvl(:OLD.L" "RR_DM,'-12345')) then if(p_sql_clause is null)then p_sql_clause:='up" "date khgl_qyjbxx set LRR_DM='''||replace(:NEW.LRR_DM,'''','''''')||''''; " "else p_sql_clause:=p_sql_clause||',LRR_DM='''||replace(:NEW.LRR_DM,'''" "','''''')||''''; end if; end if; if(nvl(:NEW.LRRQ,sysdate)!=nvl(:OLD." "LRRQ,to_date('1900-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss'))) then if(p_" "sql_clause is null)then p_sql_clause:='update khgl_qyjbxx set LRRQ=to_d" "ate('''||to_char(:NEW.LRRQ,'yyyy-mm-dd hh24:mi:ss')||''',''yyyy-mm-dd hh24:" "mi:ss'')'; else p_sql_clause:=p_sql_clause||',LRRQ=to_date('''||to_c" "har(:NEW.LRRQ,'yyyy-mm-dd hh24:mi:ss')||''',''yyyy-mm-dd hh24:mi:ss'')'; " "end if; end if; if(nvl(:NEW.ZHXQRQ,sysdate)!=nvl(:OLD.ZHXQRQ,to_date('1" "900-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss'))) then if(p_sql_clause is n" "ull)then p_sql_clause:='update khgl_qyjbxx set ZHXQRQ=to_date('''||to_c" "har(:NEW.ZHXQRQ,'yyyy-mm-dd hh24:mi:ss')||''',''yyyy-mm-dd hh24:mi:ss'')'; " " else p_sql_clause:=p_sql_clause||',ZHXQRQ=to_date('''||to_char(:NEW." "ZHXQRQ,'yyyy-mm-dd hh24:mi:ss')||''',''yyyy-mm-dd hh24:mi:ss'')'; end if;" " end if; if(nvl(:NEW.ZTBZ,'-12345')!=nvl(:OLD.ZTBZ,'-12345')) then i" "f(p_sql_clause is null)then p_sql_clause:='update khgl_qyjbxx set ZTBZ=" "'''||replace(:NEW.ZTBZ,'''','''''')||''''; else p_sql_clause:=p_sql_" "clause||',ZTBZ='''||replace(:NEW.ZTBZ,'''','''''')||''''; end if; end i" "f; if(nvl(:NEW.BZ,'-12345')!=nvl(:OLD.BZ,'-12345')) then if(p_sql_clau" "se is null)then p_sql_clause:='update khgl_qyjbxx set BZ='''||replace(:" "NEW.BZ,'''','''''')||''''; else p_sql_clause:=p_sql_clause||',BZ='''" "||replace(:NEW.BZ,'''','''''')||''''; end if; end if; if(nvl(:NEW.QYL" "X_DM,'-12345')!=nvl(:OLD.QYLX_DM,'-12345')) then if(p_sql_clause is null" ")then p_sql_clause:='update khgl_qyjbxx set QYLX_DM='''||replace(:NEW.Q" "YLX_DM,'''','''''')||''''; else p_sql_clause:=p_sql_clause||',QYLX_D" "M='''||replace(:NEW.QYLX_DM,'''','''''')||''''; end if; end if; if(" "p_sql_clause is not null)then p_sql_clause:=p_sql_clause||' where (NSR" "SBH='''||:OLD.NSRSBH||''')'; end if; select seq_syn_control_id.nextval " "into p_id from dual; insert into syn_control_send_sql(id,table_name,a" "ction_type,fzjg_dm,condition_clause,sql_clause,update_clob_fields,update_bl" "ob_fields,update_date,syn_flag) values(p_id,'khgl_qyjbxx','UPDATE',''|" "|replace(:OLD.FZJG_DM,'''','''''')||'','(NSRSBH='''||:NEW.NSRSBH||''')',p_s" "ql_clause,p_update_clob_fields,p_update_blob_fields,sysdate,'0'); end if;" " end SYN_khgl_qyjbxx_U;"IMP-00041: Warning: object created with compilation warnings "CREATE TRIGGER "KFPT2".SYN_khgl_qyjbxx_I after insert on khgl_qyjbxx for e" "ach row declare num int; p_id syn_control_send_sql.id%type; sql_claus" "e syn_control_send_sql.sql_clause%type;begin select count(1) into nu" "m from syn_control_receive_sql s where (upper(s.table_name)='khgl_qyjbxx') " "and (s.condition_clause='(NSRSBH='''||:NEW.NSRSBH||''')') and s.handle_flag" "='0'; if(num=0)then select seq_syn_control_id.nextval into p_id from " "dual; sql_clause:= 'insert into khgl_qyjbxx(LWNSRSBH,NSRSBH,NSRMC,NS" "RBM,SWJG_DM,ZCBM,NSRLB_DM,DHHM,JYDZ,ZCDZ,LXRMC,LXRSJ,XZQH_DM,KHYHMC,KHYHZH," "KPDZ,YZBM,EMAIL,JTLX,CZHM,MSN,QQ,ZGYMC,SWFS_DM,OS,DYJLX_DM,SMYXH,ISDLQY,FZJ" "G_DM,LRR_DM,LRRQ,ZHXQRQ,ZTBZ,BZ,QYLX_DM)values('''||replace(:NEW.LWNSRSBH,'" "''','''''')||''','''||replace(:NEW.NSRSBH,'''','''''')||''','''||replace(:N" "EW.NSRMC,'''','''''')||''','''||replace(:NEW.NSRBM,'''','''''')||''','''||r" "eplace(:NEW.SWJG_DM,'''','''''')||''','''||replace(:NEW.ZCBM,'''','''''')||" "''','''||replace(:NEW.NSRLB_DM,'''','''''')||''','''||replace(:NEW.DHHM,'''" "','''''')||''','''||replace(:NEW.JYDZ,'''','''''')||''','''||replace(:NEW.Z" "CDZ,'''','''''')||''','''||replace(:NEW.LXRMC,'''','''''')||''','''||replac" "e(:NEW.LXRSJ,'''','''''')||''','''||replace(:NEW.XZQH_DM,'''','''''')||'''," "'''||replace(:NEW.KHYHMC,'''','''''')||''','''||replace(:NEW.KHYHZH,'''',''" "'''')||''','''||replace(:NEW.KPDZ,'''','''''')||''','''||replace(:NEW.YZBM," "'''','''''')||''','''||replace(:NEW.EMAIL,'''','''''')||''','''||replace(:N" "EW.JTLX,'''','''''')||''','''||replace(:NEW.CZHM,'''','''''')||''','''||rep" "lace(:NEW.MSN,'''','''''')||''','''||replace(:NEW.QQ,'''','''''')||''','''|" "|replace(:NEW.ZGYMC,'''','''''')||''','''||replace(:NEW.SWFS_DM,'''',''''''" ")||''','''||replace(:NEW.OS,'''','''''')||''','''||replace(:NEW.DYJLX_DM,''" "'','''''')||''','''||replace(:NEW.SMYXH,'''','''''')||''','''||replace(:NEW" ".ISDLQY,'''','''''')||''','''||replace(:NEW.FZJG_DM,'''','''''')||''','''||" "replace(:NEW.LRR_DM,'''','''''')||''',to_date('''||to_char(:NEW.LRRQ,'yyyy-" "mm-dd hh24:mi:ss')||''',''yyyy-mm-dd hh24:mi:ss''),to_date('''||to_char(:NE" "W.ZHXQRQ,'yyyy-mm-dd hh24:mi:ss')||''',''yyyy-mm-dd hh24:mi:ss''),'''||repl" "ace(:NEW.ZTBZ,'''','''''')||''','''||replace(:NEW.BZ,'''','''''')||''','''|" "|replace(:NEW.QYLX_DM,'''','''''')||''')'; insert into syn_control_" "send_sql(id,table_name,action_type,condition_clause,sql_clause,fzjg_dm,upda" "te_clob_fields,update_blob_fields,update_date,syn_flag) values(p_id,'k" "hgl_qyjbxx','INSERT','(NSRSBH='''||:NEW.NSRSBH||''')', sql_clause ," "''||replace(:NEW.FZJG_DM,'''','''''')||'','','',sysdate,'0'); end if; e" "nd SYN_khgl_qyjbxx_I;"About to enable constraints...Import terminated successfully with warnings. 解决办法，重新编译无效的对象SQL>sqlplus / as sysdbaSQL> @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/utlrp.sqlTIMESTAMP--------------------------------------------------------------------------------COMP_TIMESTAMP UTLRP_BGN 2011-06-22 22:48:55DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalidDOC> objects in the database. Recompilation time is proportional to theDOC> number of invalid objects in the database, so this command may takeDOC> a long time to execute on a database with a large number of invalidDOC> objects.DOC>DOC> Use the following queries to track recompilation progress:DOC>DOC> 1. Query returning the number of invalid objects remaining. ThisDOC> number should decrease with time.DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);DOC>DOC> 2. Query returning the number of objects compiled so far. This numberDOC> should increase with time.DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;DOC>DOC> This script automatically chooses serial or parallel recompilationDOC> based on the number of CPUs available (parameter cpu_count) multipliedDOC> by the number of threads per CPU (parameter parallel_threads_per_cpu).DOC> On RAC, this number is added across all RAC nodes.DOC>DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallelDOC> recompilation. Jobs are created without instance affinity so that theyDOC> can migrate across RAC nodes. Use the following queries to verifyDOC> whether UTL_RECOMP jobs are being created and run correctly:DOC>DOC> 1. Query showing jobs created by UTL_RECOMPDOC> SELECT job_name FROM dba_scheduler_jobsDOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';DOC>DOC> 2. Query showing UTL_RECOMP jobs that are runningDOC> SELECT job_name FROM dba_scheduler_running_jobsDOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';DOC>#PL/SQL procedure successfully completed.TIMESTAMP--------------------------------------------------------------------------------COMP_TIMESTAMP UTLRP_END 2011-06-22 22:49:06PL/SQL procedure successfully completed.DOC> The following query reports the number of objects that have compiledDOC> with errors (objects that compile with errors have status set to 3 inDOC> obj$). If the number is higher than expected, please examine the errorDOC> messages reported with each object (using SHOW ERRORS) to see if theyDOC> point to system misconfiguration or resource constraints that must beDOC> fixed before attempting to recompile these objects.DOC>#OBJECTS WITH ERRORS------------------- 4DOC> The following query reports the number of errors caught duringDOC> recompilation. If this number is non-zero, please query the errorDOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errorsDOC> are due to misconfiguration or resource constraints that must beDOC> fixed before objects can compile successfully.DOC>#ERRORS DURING RECOMPILATION--------------------------- 0PL/SQL procedure successfully completed.造成错误的原因，参考一下解释Applies to:Oracle Server - Enterprise Edition - Version: 8.1.7.0 to 10.2.0.4This problem can occur on any platform.This note is meant for the users who get the following set of errors while performing an import:IMP-00041: Warning: object created with compilation warnings "CREATE FORCE VIEW or IMP-00041: Warning: object created with compilation warnings "CREATE TRIGGERSymptomsSometimes invalid objects indicated by IMP-00041 errors can be compiled manually after the IMPORT command is used. Other times, even after the import is complete, you are not able to compile them manually. And manually recreating them on the importing database gives: ORA-01031 : insufficient privileges or ORA-00942: table or view does not existCauseThere could be several causes for this problem:a) The objects on which you are getting the errors refer to the objects (tables, etc.) which: either do not exist in the database or lie in the other schema which, though existed in the exporting database, does not exist in the importing database.b) The importing user does not have necessary privileges on the referred objects.c) The referred objects are dba_ views or other data dictionary tables, etc.SolutionTry recompiling those objects, or use the following solution for each of the above causes:a) Either pre-create the referred objects in the importing database or pre-import the schema carrying the referred objects before carrying out the import of the schema receiving the errors.b) Provide the necessary privileges to the importing user prior to import.c) Grant 'select any table' system privilege to the importing user prior to import AND be sure the init.ora parameter 'O7_DICTIONARY_ACCESSIBILITY' is set to TRUE on the importing database.Note: The init.ora parameter 'O7_DICTIONARY_ACCESSIBILITY' parameter is by default FALSE in Oracle9i and TRUE in Oracle8i. For more information on init.ora parameter 'O7_DICTIONARY_ACCESSIBILITY', please refer to Note 47316.1
