DBA_OBJECTS v10

The DBA_OBJECTS view provides information about all objects in the database.

NameTypeDescription
ownerTEXTUser name of the object’s owner.
schema_nameTEXTName of the schema in which the object belongs.
object_nameTEXTName of the object.
object_typeTEXTType of the object – possible values are: INDEX, FUNCTION, PACKAGE, PACKAGE BODY, PROCEDURE, SEQUENCE, SYNONYM, TABLE, TRIGGER, and VIEW
statusCHARACTER VARYINGIncluded for compatibility only; always set to VALID.
temporaryTEXTY if the table is temporary; N if the table is permanent.