DBA_OBJECTS view reference for all database objects - PolarDB

DBA_OBJECTS is a system view that returns metadata for all objects in the database.

Column reference

Column	Type	Description
`owner`	TEXT	Username of the object owner.
`schema_name`	TEXT	Name of the schema that contains the object.
`object_name`	TEXT	Name of the object.
`object_type`	TEXT	Type of the object. Valid values: `INDEX`, `FUNCTION`, `PACKAGE`, `PACKAGE BODY`, `PROCEDURE`, `SEQUENCE`, `SYNONYM`, `TABLE`, `TRIGGER`, and `VIEW`.
`status`	CHARACTER VARYING	Validity status of the object. Included for Oracle compatibility only. Always set to `VALID`.
`temporary`	TEXT	`Y` if the table is a temporary table, `N` if the table is a permanent table.
`last_ddl_time`	TIMESTAMP WITH TIME ZONE	Timestamp of the last DDL statement executed on the object.
`data_object_id`	OID	Object identifier (OID) of the data.
`subobject_name`	TEXT	Name of the subobject (for example, a partition name).
`object_id`	OID	Object identifier.

status is included for compatibility with Oracle applications that query this column. Its value is always VALID regardless of the actual object state — do not use it as a filter condition.
Query ALL_OBJECTS to view objects accessible to the current user, or USER_OBJECTS to view objects owned by the current user.