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
  • Y: The object is a temporary object.
  • N: The object is a permanent object.