2.233 ALL_OBJECTS
ALL_OBJECTS
describes all objects accessible to the current user.
Related Views
-
DBA_OBJECTS
describes all objects in the database. -
USER_OBJECTS
describes all objects owned by the current user. This view does not display theOWNER
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 that contains the object. Note: |
|
|
|
Type of the object (such as |
|
|
|
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:
|
|
|
|
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 |
|
|
|
Indicates whether the object is an Application common object ( |
|
|
|
Default collation for the object |
|
|
|
Indicates whether this object is duplicated on this shard ( |
|
|
|
Indicates whether this object is sharded ( |
|
|
|
ID of the Application that created the object |
|
|
|
ID of the Application Version that created the object |
|
|
|
ID of the Application that last modified the object |
|
|
|
ID of the Application Version that last modified the object |
See Also: