EXA_DBA_SCHEMA_OBJECTS

The system table lists all objects in the current schema. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Column Description
OBJECT_NAME Name of the object
OBJECT_TYPE Type of the object