Hy @ everybody,
at a Oracle 11G R2 instance, 11.2.0.3.0, I'm trying to recompile some invalid objects like explained here:
[http://www.oracle-base.com/articles/misc/recompiling-invalid-schema-objects.php]
I've some invalic Objects in "XDB" and "SYS" Schema.
When i try to fix them with "utlprp.sql" at level 1 I'm getting this output:
FAILED CHECK FOR PACKAGE BODY CTX_DOC
Warning: XDB now invalid, invalid objects found:
object_name object_type
-------------------------------------------------------
DBMS_XMLDOM PACKAGE BODY
DBMS_XMLPARSER PACKAGE BODY
DBMS_XSLPROCESSOR PACKAGE BODY
DBMS_XDBRESOURCE PACKAGE BODY
DBMS_XDB PACKAGE BODY
DBMS_XDBUTIL_INT PACKAGE BODY
DBMS_CSX_INT PACKAGE BODY
DBMS_XMLSCHEMA PACKAGE BODY
PATH_VIEW VIEW
XDB_PV_TRIG TRIGGER
XIMETADATA_PKG PACKAGE BODY
DBMS_XDBT PACKAGE BODY
PL/SQL-Prozedur erfolgreich abgeschlossen.
and when i select the invalid objects with:
SELECT owner, object_type, object_name, status
FROM dba_objects
WHERE status = 'INVALID'
ORDER BY owner, object_type, object_name;
The number of invalid objects are still the same as before executing the "utlprp.sql" script. I've tried it also manually by:
ALTER PACKAGE my_package COMPILE;
ALTER PACKAGE my_package COMPILE BODY;
ALTER PROCEDURE my_procedure COMPILE;
ALTER FUNCTION my_function COMPILE;
ALTER TRIGGER my_trigger COMPILE;
ALTER VIEW my_view COMPILE;
or with:
EXEC DBMS_DDL.alter_compile('PACKAGE', 'MY_SCHEMA', 'MY_PACKAGE');
EXEC DBMS_DDL.alter_compile('PACKAGE BODY', 'MY_SCHEMA', 'MY_PACKAGE');
EXEC DBMS_DDL.alter_compile('PROCEDURE', 'MY_SCHEMA', 'MY_PROCEDURE');
EXEC DBMS_DDL.alter_compile('FUNCTION', 'MY_SCHEMA', 'MY_FUNCTION');
EXEC DBMS_DDL.alter_compile('TRIGGER', 'MY_SCHEMA', 'MY_TRIGGER');
but everytime Oracle prints me, that the objects was recompiled with compiling errors.
Does anybody know, how i fix that?
Thanks a lot and best regards,
David