在采用IMPDP/IMP工具迁移数据时，经常会提示无效对象的警告，需要采用如下方式处理。
采用H5响应式网站+css3国际标准网站建设，让网站自动适应用户使用终端设备，PC、平板、手机等，一个网址适应，一套内容统一战略，节约企业资源。创新互联还提供网站后期营销如：软文平台、卖链接、广告投放等。一般建站公司不为企业填充资料，更谈不上内容策划，结果导致网站界面优秀，内容却十分空泛或整体不协调，内容策划、内容填充请交给我们。
su – oracle
sqlplus / as sysdba
SQL> select owner,object_name,replace(object_type,' ','') object_type,to_char(created,'yyyy-mm-dd') as created,to_char(last_ddl_time,'yyyy-mm-dd') as last_ddl_time,status from dba_objects where status='INVALID' and owner='HKJJW';
OWNER OBJECT_NAME OBJECT_TYPE CREATED LAST_DDL_T STATUS
---------- ------------------------------ --------------- ---------- ---------- -------
HKJJW FUNC_RETURN_PY FUNCTION 2013-08-02 2013-08-02 INVALID
HKJJW MONITORING_FLOW_PARALLEL_VIEW VIEW 2013-08-02 2013-08-02 INVALID
HKJJW TEST VIEW 2013-08-02 2013-08-02 INVALID
指定查询某用户无效对象。
SQL> select * from dba_objects where status<>'VALID' and owner='HKJJW';
ALTER FUNCTION HKJJW.FUNC_RETURN_PY COMPILE;
ALTER VIEW HKJJW.MONITORING_FLOW_PARALLEL_VIEW COMPILE;
ALTER VIEW HKJJW.TEST COMPILE;
如果是index的话,需要重建.
alter index index_name rebuild;
如果是package body
alter package DBMS_CUBE compile body;
SQL> select owner,object_type,status,count(*) from dba_objects where status='INVALID' group by owner,object_type,status order by owner,object_type;
OWNER OBJECT_TYPE STATUS COUNT(*)
------------------------------ ------------------- ------- ----------
HNADEV_GROUP FUNCTION INVALID 1
HNADEV_GROUP PACKAGE BODY INVALID 35
HNADEV_GROUP VIEW INVALID 7
SQL> select 'ALTER ' || OBJECT_TYPE || ' ' || OWNER || '.' || OBJECT_NAME || ' COMPILE;' from dba_objects where status = 'INVALID' and object_type in ('PACKAGE','PACKAGE BODY','FUNCTION','PROCEDURE','TRIGGER','VIEW') ;
'ALTER'||OBJECT_TYPE||''||OWNER||'.'||OBJECT_NAME||'COMPILE;'
----------------------------------------------------------------------
ALTER VIEW HNADEV_GROUP.V_E_T_FEEMONTH_CAL COMPILE;
ALTER VIEW HNADEV_GROUP.V_E_T_FEEMONTH COMPILE;
ALTER VIEW HNADEV_GROUP.V_E_Z_BILL_STAY_GROUP COMPILE;
略...
通过复制以上SQL语句,直接手动执行编译执行.
# su - oracle
$ sqlplus / as sysdba
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
