EXA_ALL_SCHEMA_OBJECTS

The system table lists all objects in the current schema to which the current user has access. All users have access to the table.

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