[Home] [Help] [Dependency Information]
Object Name: | ALL_OBJECTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Objects accessible to the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Username of the owner of the object |
OBJECT_NAME | VARCHAR2 | (128) | Yes | Name of the object |
SUBOBJECT_NAME | VARCHAR2 | (128) | Name of the sub-object (for example, partititon) | |
OBJECT_ID | NUMBER | Yes | Object number of the object | |
DATA_OBJECT_ID | NUMBER | Object number of the segment which contains the object | ||
OBJECT_TYPE | VARCHAR2 | (23) | Type of the object | |
CREATED | DATE | Yes | Timestamp for the creation of the object | |
LAST_DDL_TIME | DATE | Yes | Timestamp for the last DDL change (including GRANT and REVOKE) to the object | |
TIMESTAMP | VARCHAR2 | (19) | Timestamp for the specification of the object | |
STATUS | VARCHAR2 | (7) | Status of the object | |
TEMPORARY | VARCHAR2 | (1) | Can the current session only see data that it placed in this object itself? | |
GENERATED | VARCHAR2 | (1) | Was the name of this object system generated? | |
SECONDARY | VARCHAR2 | (1) | Is this a secondary object created as part of icreate for domain indexes? | |
NAMESPACE | NUMBER | Yes | Namespace for the object | |
EDITION_NAME | VARCHAR2 | (128) | Name of the edition in which the object is actual | |
SHARING | VARCHAR2 | (13) | Is this a Metadata Link, an Object Link or neither? | |
EDITIONABLE | VARCHAR2 | (1) | Object is considered editionable | |
ORACLE_MAINTAINED | VARCHAR2 | (1) | Denotes whether the object was created, and is maintained, by Oracle-supplied scripts. An object for which this has the value Y must not be changed in any way except by running an Oracle-supplied script. |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, OBJECT_NAME
, SUBOBJECT_NAME
, OBJECT_ID
, DATA_OBJECT_ID
, OBJECT_TYPE
, CREATED
, LAST_DDL_TIME
, TIMESTAMP
, STATUS
, TEMPORARY
, GENERATED
, SECONDARY
, NAMESPACE
, EDITION_NAME
, SHARING
, EDITIONABLE
, ORACLE_MAINTAINED
FROM SYS.ALL_OBJECTS;
|
|
|