This Table is provided by oracle and lists types of dependent and referenced objects. However this table gives no indication of if it is comprehensive or just a list of examples of the types of object that can be either dependent or referenced.
Does anyone know if this is:
A) Comprehensive
Or
B) Have any examples of other objects that can be either dependent or referenced.
I would say the list is not comprehensive as I just queried DBA_DEPENDENCIES on one of our heavily used databases and a lot more popped out on my list than is listed in Figure 20-1 on the referenced page.
Keep in mind these are just distinct dependencies that exist in the database I chose. If you want to get fancy you can check out the source code of DBA_DEPENDENCIES and probably find out the comprehensive list of dependencies available.
Keep in mind there are some caveats on relying on this table. Such as if you have Dynamic SQL inside of a stored procedure -- objects referenced in Dynamic SQL will not be included in the relationships listed in DBA_DEPENDENCIES.
select distinct type from dba_dependencies order by 1;
TYPE
DIMENSION
EVALUATION CONTXT
FUNCTION
INDEX
INDEXTYPE
JAVA CLASS
JAVA DATA
MATERIALIZED VIEW
OPERATOR
PACKAGE
PACKAGE BODY
PROCEDURE
RULE
RULE SET
SYNONYM
TABLE
TRIGGER
TYPE
TYPE BODY
UNDEFINED
VIEW
XML SCHEMA
select distinct referenced_type from dba_dependencies order by 1;
REFERENCED_TYPE
EVALUATION CONTXT
FUNCTION
INDEXTYPE
JAVA CLASS
LIBRARY
NON-EXISTENT
OPERATOR
PACKAGE
PROCEDURE
SEQUENCE
SYNONYM
TABLE
TYPE
VIEW
XML SCHEMA
