The USER_OBJECTS view provides the information about all objects that are owned by the current user.
| Parameter | Type | Description |
|---|---|---|
| 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 |
|
| last_ddl_time | DATE | Timestamp for the last modification of the object resulting from a DDL statement. |
| data_object_id | NUMBER | Object number of the segment that contains the object. |
| subobject_name | TEXT | Name of the subobject. |
| object_id | NUMBER | The ID of the object. |