ALL_OBJECTS_AE
describes the objects (across all editions) accessible to the current user. Dropped objects appear in this view with OBJECT_TYPE
=
NON-EXISTENT
.
Related Views
DBA_OBJECTS_AE
describes all objects (across all editions) in the database.
USER_OBJECTS_AE
describes the objects (across all editions) owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the object |
|
|
|
Name of the object |
|
|
Name of the subobject (for example, partition) |
|
|
|
|
Dictionary object number of the object |
|
|
Dictionary object number of the segment which contains the object |
|
|
|
Type of the object |
|
|
|
|
Timestamp for the creation of the object |
|
|
|
Timestamp for the last modification of the object and dependent objects resulting from a DDL statement (including grants and revokes) |
|
|
Timestamp for the specification of the object (character data) |
|
|
|
Status of the object:
|
|
|
|
Indicates whether the object is temporary (the current session can see only data that it placed in this object itself) ( |
|
|
|
Indicates whether the name of this object was system-generated ( |
|
|
|
Indicates whether this is a secondary object created by the |
|
|
|
|
Namespace for the object |
|
|
Name of the edition in which the object is actual |
|
|
|
Values:
|
|
|
|
Denotes whether the object was created, and is maintained, by Oracle-supplied scripts (such as catalog.sql or catproc.sql). An object for which this column has the value |
See Also: