ALL_OBJECTS

This view lists all the database objects the current user can access. As for many ALL_ views, there are similar DBA_OBJECTS and USER_OBJECTS views; they have the same fields but DBA_OBJECTS shows all the objects in the database, while USER_OBJECTS shows information only on the objects of the current user.

This view is often joined to other dynamic performance views, for example, V$LOCKED_OBJECT, by OBJECT_ID to obtain the object name and owner.

Fields

The most relevant view fields are as follows:

• OWNER: The owner of the object

• OBJECT_NAME: The name of the object

• OBJECT_ID: The unique ID associated to the object in the data dictionary

• OBJECT_TYPE: The object type, such as TABLE, INDEX, and so on

• CREATED: The timestamp for the creation of the object

• STATUS: The status of the object, such as VALID, INVALID, or N/A