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