ALL_OBJECTS v17

The ALL_OBJECTS view provides information about all objects that reside 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
createdDATETimestamp for when the object was created.
last_ddl_timeDATETimestamp for the last modification of an object resulting from a DDL statement, including grants and revokes.
statusCHARACTER VARYINGWhether or not the state of the object is valid. Included only for compatibility. Always set to VALID.
temporaryTEXTY if a temporary object, N if this is a permanent object.