Table missing?

[pytao]

I tried to run the following statement to recompile any invalid objects in the proper order:
--------------------------------------------------------------------
select
decode( OBJECT_TYPE, 'PACKAGE BODY',
'alter package ' || OWNER||'.'||OBJECT_NAME || ' compile body;',
'alter ' || OBJECT_TYPE || ' ' || OWNER||'.'||OBJECT_NAME || ' compile;' )
from
dba_objects a,
sys.order_object_by_dependency b
where
A.OBJECT_ID = B.OBJECT_ID(+) and
STATUS = 'INVALID' and
OBJECT_TYPE in ( 'PACKAGE BODY', 'PACKAGE', 'FUNCTION', 'PROCEDURE',
'TRIGGER', 'VIEW' )
order by
DLEVEL DESC,
OBJECT_TYPE,
OBJECT_NAME;
--------------------------------------------------------------------
However, in SQLPLUS it's telling me that the sys.order_object_by_dependency table doesn't exist, how can I create this table?

Thanks

[adewri]

Since 8.1.6.2, this view does not exist anymore.
cause: Bug:895238

The original query for order_object_by_dependency is:

select max(level), object_id from public_dependency
connect by object_id = prior referenced_object_id
group by object_id;

However, if there are JAVA objects in the database, this query will fail with ORA-1436.

HTH
Amar