eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS._CURRENT_EDITION_OBJ

Object Details

Object Name:	_CURRENT_EDITION_OBJ
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
OBJ#	NUMBER		Yes
DATAOBJ#	NUMBER
DEFINING_OWNER#	NUMBER		Yes
NAME	VARCHAR2	(128)	Yes
NAMESPACE	NUMBER		Yes
SUBNAME	VARCHAR2	(128)
TYPE#	NUMBER		Yes
CTIME	DATE		Yes
MTIME	DATE		Yes
STIME	DATE		Yes
STATUS	NUMBER		Yes
REMOTEOWNER	VARCHAR2	(128)
LINKNAME	VARCHAR2	(128)
FLAGS	NUMBER
OID$	RAW	(16)
SPARE1	NUMBER
SPARE2	NUMBER
SPARE3	NUMBER
SPARE4	VARCHAR2	(1000)
SPARE5	VARCHAR2	(1000)
SPARE6	DATE
SIGNATURE	RAW	(16)
SPARE7	NUMBER
SPARE8	NUMBER
SPARE9	NUMBER
OWNER#	NUMBER
DEFINING_EDITION	VARCHAR2	(128)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OBJ#
,      DATAOBJ#
,      DEFINING_OWNER#
,      NAME
,      NAMESPACE
,      SUBNAME
,      TYPE#
,      CTIME
,      MTIME
,      STIME
,      STATUS
,      REMOTEOWNER
,      LINKNAME
,      FLAGS
,      OID$
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
,      SIGNATURE
,      SPARE7
,      SPARE8
,      SPARE9
,      OWNER#
,      DEFINING_EDITION
FROM SYS._CURRENT_EDITION_OBJ;

Dependencies

[top of page]

SYS._CURRENT_EDITION_OBJ references the following:

SYS: OBJ$; USER$; USER_EDITIONING$

SYS._CURRENT_EDITION_OBJ is referenced by following:

SYS: ALL_ASSEMBLIES; ALL_ASSOCIATIONS; ALL_CATALOG; ALL_CODE_ROLE_PRIVS; ALL_COLL_TYPES; ALL_COL_PRIVS; ALL_COL_PRIVS_MADE; ALL_COL_PRIVS_RECD; ALL_CONS_COLUMNS; ALL_CONS_OBJ_COLUMNS; ALL_DEPENDENCIES; ALL_EDITIONING_VIEWS; ALL_EDITIONING_VIEW_COLS; ALL_ERRORS; ALL_ERROR_TRANSLATIONS; ALL_METHOD_PARAMS; ALL_METHOD_RESULTS; ALL_NESTED_TABLES; ALL_OBJECTS; ALL_OBJ_COLATTRS; ALL_PLSQL_COLL_TYPES; ALL_PLSQL_TYPES; ALL_PLSQL_TYPE_ATTRS; ALL_SQLJ_TYPES; ALL_SQLJ_TYPE_ATTRS; ALL_SQLJ_TYPE_METHODS; ALL_SQL_TRANSLATIONS; ALL_SQL_TRANSLATION_PROFILES; ALL_STAT_EXTENSIONS; ALL_SYNONYMS; ALL_TAB_COLS_V$; ALL_TAB_PRIVS; ALL_TAB_PRIVS_MADE; ALL_TAB_PRIVS_RECD; ALL_TRIGGERS; ALL_TRIGGER_COLS; ALL_TSTZ_TAB_COLS; ALL_TYPES; ALL_TYPE_ATTRS; ALL_TYPE_METHODS; ALL_TYPE_VERSIONS; ALL_UPDATABLE_COLUMNS; ALL_VARRAYS; ALL_WARNING_SETTINGS; COL; COLUMN_PRIVILEGES; DBA_ASSEMBLIES; DBA_ASSOCIATIONS; DBA_CATALOG; DBA_CODE_ROLE_PRIVS; DBA_COLL_TYPES; DBA_COL_PRIVS; DBA_CONS_COLUMNS; DBA_CONS_OBJ_COLUMNS; DBA_CONTAINER_DATA; DBA_DEPENDENCIES; DBA_EDITIONING_VIEWS; DBA_EDITIONING_VIEW_COLS; DBA_ERRORS; DBA_ERROR_TRANSLATIONS; DBA_METHOD_PARAMS; DBA_METHOD_RESULTS; DBA_NESTED_TABLES; DBA_OBJECTS; DBA_OBJECT_SIZE; DBA_OBJ_AUDIT_OPTS; DBA_OBJ_COLATTRS; DBA_OLDIMAGE_COLUMNS; DBA_PLSQL_COLL_TYPES; DBA_PLSQL_TYPES; DBA_PLSQL_TYPE_ATTRS; DBA_POLICIES; DBA_POLICY_ATTRIBUTES; DBA_RECYCLEBIN; DBA_SQLJ_TYPES; DBA_SQLJ_TYPE_ATTRS; DBA_SQLJ_TYPE_METHODS; DBA_SQL_TRANSLATIONS; DBA_SQL_TRANSLATION_PROFILES; DBA_STAT_EXTENSIONS; DBA_TAB_COLS_V$; DBA_TAB_PRIVS; DBA_TRIGGERS; DBA_TRIGGER_COLS; DBA_TYPES; DBA_TYPE_ATTRS; DBA_TYPE_METHODS; DBA_TYPE_VERSIONS; DBA_UPDATABLE_COLUMNS; DBA_VARRAYS; DBA_WARNING_SETTINGS; DBMS_DDL_INTERNAL - show dependent code; DBMS_PICKLER - show dependent code; DISK_AND_FIXED_OBJECTS; DMP_SEC - show dependent code; INT$DBA_ARGUMENTS; INT$DBA_COL_COMMENTS; INT$DBA_IDENTIFIERS; INT$DBA_LIBRARIES; INT$DBA_PLSQL_OBJECT_SETTINGS; INT$DBA_PROCEDURES; INT$DBA_SOURCE; INT$DBA_STORED_SETTINGS; INT$DBA_SYNONYMS; INT$DBA_TAB_COMMENTS; INT$DBA_VIEWS; INT$INT$DBA_CONSTRAINTS; KU$_ALL_TSLTZ_TAB_COLS; LOADER_TRIGGER_INFO; ROLE_TAB_PRIVS; SYNONYMS; SYSCATALOG_; TAB; TABLE_PRIVILEGES; TTS_OBJ_VIEW; USER_ASSEMBLIES; USER_ASSOCIATIONS; USER_CATALOG; USER_CODE_ROLE_PRIVS; USER_COLL_TYPES; USER_COL_PRIVS; USER_COL_PRIVS_MADE; USER_COL_PRIVS_RECD; USER_CONS_COLUMNS; USER_CONS_OBJ_COLUMNS; USER_DEPENDENCIES; USER_EDITIONING_VIEWS; USER_EDITIONING_VIEW_COLS; USER_ERRORS; USER_ERROR_TRANSLATIONS; USER_METHOD_PARAMS; USER_METHOD_RESULTS; USER_NESTED_TABLES; USER_OBJECTS; USER_OBJECT_SIZE; USER_OBJ_AUDIT_OPTS; USER_OBJ_COLATTRS; USER_OLDIMAGE_COLUMNS; USER_PLSQL_COLL_TYPES; USER_PLSQL_TYPES; USER_PLSQL_TYPE_ATTRS; USER_RECYCLEBIN; USER_SQLJ_TYPES; USER_SQLJ_TYPE_ATTRS; USER_SQLJ_TYPE_METHODS; USER_SQL_TRANSLATIONS; USER_SQL_TRANSLATION_PROFILES; USER_STAT_EXTENSIONS; USER_TAB_COLS_V$; USER_TAB_PRIVS; USER_TAB_PRIVS_MADE; USER_TAB_PRIVS_RECD; USER_TRIGGERS; USER_TRIGGER_COLS; USER_TYPES; USER_TYPE_ATTRS; USER_TYPE_METHODS; USER_TYPE_VERSIONS; USER_UPDATABLE_COLUMNS; USER_VARRAYS; USER_WARNING_SETTINGS; _ALL_SYNONYMS_FOR_AUTH_OBJECTS; _DBA_TRIGGER_ORDERING; _INT$_ALL_SYNONYMS_FOR_AO; _INT$_ALL_SYNONYMS_FOR_SYN