IMP-00041: Warning: object created with compilation warnings

54yg

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  sysdba

SQL> @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/utlrp.sql

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN  2011-06-22 22:48:55

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC>   objects in the database. Recompilation time is proportional to the
DOC>   number of invalid objects in the database, so this command may take
DOC>   a long time to execute on a database with a large number of invalid
DOC>   objects.
DOC>
DOC>   Use the following queries to track recompilation progress:
DOC>
DOC>   1. Query returning the number of invalid objects remaining. This
DOC>      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 number
DOC>      should increase with time.
DOC>         SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC>   This script automatically chooses serial or parallel recompilation
DOC>   based on the number of CPUs available (parameter cpu_count) multiplied
DOC>   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 parallel
DOC>   recompilation. Jobs are created without instance affinity so that they
DOC>   can migrate across RAC nodes. Use the following queries to verify
DOC>   whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC>   1. Query showing jobs created by UTL_RECOMP
DOC>         SELECT job_name FROM dba_scheduler_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC>   2. Query showing UTL_RECOMP jobs that are running
DOC>         SELECT job_name FROM dba_scheduler_running_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#

PL/SQL procedure successfully completed.


TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END  2011-06-22 22:49:06


PL/SQL procedure successfully completed.

DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS
-------------------
                  4

DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
                          0


PL/SQL procedure successfully completed.

造成错误的原因，参考一下解释

Applies to:
Oracle Server - Enterprise Edition - Version: 8.1.7.0 to 10.2.0.4
This 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 TRIGGER

Symptoms
Sometimes 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 exist

Cause
There 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.

Solution
Try 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