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
  • Y: indicates that the table is a temporary table.
  • N: indicates that the table is a permanent table.