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 Name Description
OBJECT_NAME Name of the object
OBJECT_TYPE Type of the object