The USER_OBJECTS view provides information about all database objects owned by the current user.
| Column name | Data type | Description |
|---|---|---|
OBJECT_NAME |
VARCHAR2(30) |
The name of the object. Always INLINE. |
OBJECT_ID |
TT_BIGINT |
The number of the dictionary object. Always NOT NULL. |
OBJECT_TYPE |
VARCHAR2(17) |
The type of the object. The possible values are:
Always NOT NULL, INLINE. |
CREATED |
DATE |
The timestamp when the object is created. Always NOT NULL. |
LAST_DDL_TIME |
DATE |
The timestamp of the last modification to the object caused by a DDL statement. Always NOT NULL. |
TIMESTAMP |
VARCHAR2(78) |
The timestamp when the object specification was defined. Always NOT NULL, INLINE. |
STATUS |
VARCHAR2(7) |
The status of the object. The possible values are:
Always NOT NULL, INLINE. |
TEMPORARY |
VARCHAR2(1) |
Specifies whether the object is temporary (Y) or permanent (N). Always Y, NOT NULL, INLINE. |
GENERATED |
VARCHAR2(1) |
Specifies whether the object is user-generated (N) or system-generated (Y). Always N, NOT NULL, INLINE. |
SECONDARY |
VARCHAR2(1) |
Specifies whether a secondary object was created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N).Always N, NOT NULL, INLINE. |
NAMESPACE |
TT_INTEGER |
The namespace for the object. Always NOT NULL. |