From:Steve Adams
Date:27-Feb-2001 13:56
Subject:   NON-EXISTENT objects in OBJ$

If an object depends on another object that does not exist, then Oracle sometimes needs to represent that non-existent object in OBJ$ for dependency management reasons. Here is an example ...

        SQL> create table t as select * from dual;

        Table created.

        SQL> create view v as select * from t;

        View created.

        SQL> drop table t;

        Table dropped.

        SQL> select * from v;
        select * from v
                      *
        ERROR at line 1:
        ORA-04063: view "TEST.V" has errors

        SQL> select distinct name, type# from sys.obj$ where name like '_';

        NAME                                TYPE#
        ------------------------------ ----------
        V                                       4
        T                                      10

        SQL>

What are objects with "type = 10" in SYS.OBJ$? In the DBA_OBJECTS view it's excluded as "NON-EXISTENT", but there are a few objects of this type.