ALL_OBJECTS v17
The ALL_OBJECTS
view provides information about all objects that reside in the database.
Name | Type | Description |
---|---|---|
owner | TEXT | User name of the object’s owner. |
schema_name | TEXT | Name of the schema in which the object belongs. |
object_name | TEXT | Name of the object. |
object_type | TEXT | Type of the object. Possible values are: INDEX , FUNCTION , PACKAGE , PACKAGE BODY , PROCEDURE , SEQUENCE , SYNONYM , TABLE , TRIGGER , and VIEW |
created | DATE | Timestamp for when the object was created. |
last_ddl_time | DATE | Timestamp for the last modification of an object resulting from a DDL statement, including grants and revokes. |
status | CHARACTER VARYING | Whether or not the state of the object is valid. Included only for compatibility. Always set to VALID . |
temporary | TEXT | Y if a temporary object, N if this is a permanent object. |