Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_OBJECTS

Object Details
Object Name: ALL_OBJECTS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Objects accessible to the user

[View Source]

Columns
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.
Query Text

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;

Dependencies

[top of page]

SYS.ALL_OBJECTS references the following:

SchemaSYS
TableDEPENDENCY$
TableDUAL
TableIND$
TableOBJ$
TableOBJAUTH$
TableOLAP_CUBES$
TableSUM$
TableTABCOMPART$
TableTABPART$
TableTABSUBPART$
TableTRIGGER$
TableUSER$
PL/SQL PackageXML_SCHEMA_NAME_PRESENT - show dependent code
View_ACTUAL_EDITION_OBJ
View_CURRENT_EDITION_OBJ
SYS.ALL_OBJECTS is referenced by following:

SchemaAPPS
Package BodyAMS_LIST_RUNNING_TOTAL_PVT - show dependent code
Package BodyEGO_EXT_FWK_PUB - show dependent code
Package BodyEGO_ITEM_PVT - show dependent code
Package BodyEGO_USER_ATTRS_DATA_PVT - show dependent code
Package BodyHZ_IMP_DQM_STAGE - show dependent code
Package BodyHZ_MERGE_DICTIONARY_PKG - show dependent code
Package BodyHZ_MIXNM_DYNAMIC_PKG_GENERATOR - show dependent code
Package BodyHZ_MIXNM_REGISTRY_PUB - show dependent code
Package BodyHZ_PARTY_STAGE - show dependent code
Package BodyJTF_TERR_RPT - show dependent code
Package BodyPVX_UTILITY_PVT - show dependent code
Package BodyZX_PTP_IMPORT - show dependent code
SchemaDVSYS
ViewDV$OUT
SchemaPUBLIC
SynonymALL_OBJECTS
SchemaSYS
ViewALL_PROBE_OBJECTS
ViewALL_REPCATLOG
ViewALL_REPFLAVOR_OBJECTS
ViewALL_REPGENERATED
ViewALL_REPGENOBJECTS
ViewALL_REPOBJECT
ViewALL_STREAMS_COLUMNS
ViewALL_STREAMS_NEWLY_SUPPORTED
ViewALL_STREAMS_UNSUPPORTED
Package BodyDBMS_AQ_IMPORT_INTERNAL - show dependent code
Package BodyDBMS_AW_EXP - show dependent code
Package BodyDBMS_COMPARISON - show dependent code
Package BodyDBMS_COMPRESSION - show dependent code
Package BodyDBMS_DATA_MINING - show dependent code
Package BodyDBMS_DBFS_CONTENT - show dependent code
Package BodyDBMS_DBFS_SFS - show dependent code
Package BodyDBMS_DBFS_SFS_ADMIN - show dependent code
Package BodyDBMS_EDITIONS_UTILITIES - show dependent code
Package BodyDBMS_INTERNAL_LOGSTDBY - show dependent code
Package BodyDBMS_OFFLINE_RGT_INTERNAL - show dependent code
Package BodyDBMS_PICKLER - show dependent code
Package BodyDBMS_RESULT_CACHE - show dependent code
Package BodyDBMS_SQL_TRANSLATOR - show dependent code
Package BodyDBMS_SQL_TRANSLATOR_EXPORT - show dependent code
Package BodyDBMS_SYNC_REFRESH - show dependent code
Package BodyDBMS_UTILITY - show dependent code
Package BodyDBMS_XMLQUERY - show dependent code
FunctionLOGMNR$ALWSUPLOG_TABF_PUBLIC
Package BodyPRVT_COMPRESSION - show dependent code
ProcedureVALIDATE_DV - show dependent code
ProcedureVALIDATE_ODM - show dependent code
ProcedureVALIDATE_OLS - show dependent code
View_ALL_REPFLAVOR_OBJECTS
View_ALL_REPL_NESTED_TABLE_NAMES