The DBA_OBJECTS view provides the information about all objects in the database.
Parameter | Type | Description |
---|---|---|
owner | TEXT | The username of the owner to which the 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 | This parameter is supported for compatibility only. The value is VALID. |
temporary | TEXT |
|