The ALL_OBJECTS view provides the information about all objects in a database.
Parameter | Type | Description |
owner | TEXT | The username of the owner to which an object belongs. |
schema_name | TEXT | The name of the schema to which the object belongs. |
object_name | TEXT | The name of the object. |
object_type | TEXT | The type of the object. Valid values: INDEX, FUNCTION, PACKAGE, PACKAGE BODY, PROCEDURE, SEQUENCE, SYNONYM, TABLE, TRIGGER, and VIEW. |
status | CHARACTER VARYING | Indicates whether the state of the object is valid. This parameter is supported for compatibility only. The value is VALID. |
temporary | TEXT |
|
last_ddl_time | TIMESTAMP WITH TIME ZONE | The time when the DDL statement was last executed. |
data_object_id | OID | The object identifier (OID) of data. |
subobject_name | TEXT | The name of the subobject. |
object_id | OID | The object identifier. |