执行语句 检查对象是否可用

Select * From Dba_Objects Where Status<>'VALID';
Exec Dbms_Utility.Compile_Schema('CATT');
Exec Dbms_Utility.Compile_Schema('OBJTYP');
Exec Dbms_Utility.Compile_Schema('UTL');
Exec Dbms_Utility.Compile_Schema('GCE_TRANS');
Exec Dbms_Utility.Compile_Schema('GCE_META');
Exec Dbms_Utility.Compile_Schema('CSW_AUDIT');
Exec Dbms_Utility.Compile_Schema('GCE_METRICS');
exec DBMS_UTILITY.COMPILE_SCHEMA('OPGCEP2');