ALL_OBJECTS describes all objects accessible to the current user.
DBA_OBJECTS describes all objects in the database.
USER_OBJECTS describes all objects owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the object |
OBJECT_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the object |
SUBOBJECT_NAME |
VARCHAR2(30) |
Name of the subobject (for example, partition) | |
OBJECT_ID |
NUMBER |
NOT NULL |
Dictionary object number of the object |
DATA_OBJECT_ID |
NUMBER |
Dictionary object number of the segment that contains the object | |
Note: OBJECT_ID and DATA_OBJECT_ID display data dictionary metadata. Do not confuse these numbers with the unique 16-byte object identifier (object ID) that Oracle Database assigns to row objects in object tables in the system. |
|||
OBJECT_TYPE |
VARCHAR2(19) |
Type of the object (such as TABLE, INDEX) |
|
CREATED |
DATE |
NOT NULL |
Timestamp for the creation of the object |
LAST_DDL_TIME |
DATE |
NOT NULL |
Timestamp for the last modification of the object and dependent objects resulting from a DDL statement (including grants and revokes) |
TIMESTAMP |
VARCHAR2(19) |
Timestamp for the specification of the object (character data) | |
STATUS |
VARCHAR2(7) |
Status of the object:
|
|
TEMPORARY |
VARCHAR2(1) |
Indicates whether the object is temporary (the current session can see only data that it placed in this object itself) (Y) or not (N) |
|
GENERATED |
VARCHAR2(1) |
Indicates whether the name of this object was system-generated (Y) or not (N) |
|
SECONDARY |
VARCHAR2(1) |
Indicates whether this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N) |
|
NAMESPACE |
NUMBER |
NOT NULL |
Namespace for the object |
EDITION_NAME |
VARCHAR2(30) |
Name of the edition in which the object is actual |