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

VIEW: SYS.EXU9MVL

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
CTOBJ# NUMBER
Yes
LOG_OWNER VARCHAR2 (128) Yes
LOG_NAME VARCHAR2 (128) Yes
LOG_OWNERID NUMBER
Yes
CREATED_TIME DATE
Yes
FILE_VERSION NUMBER

USING_ROWID_FLAG NUMBER

USING_PRIMARYKEY_FLAG NUMBER

USING_OID_FLAG NUMBER

USING_SEQUENCE_FLAG NUMBER

CHANGE_SET_NAME VARCHAR2 (128) Yes
SOURCE_SCHEMA_NAME VARCHAR2 (128) Yes
SOURCE_TABLE_NAME VARCHAR2 (128) Yes
CREATED_SCN NUMBER

MVL_FLAG NUMBER

CAPTURED_VALUES CHAR (1) Yes
MVL_TEMP_LOG VARCHAR2 (128)
MVL_V7TRIGGER VARCHAR2 (128)
LAST_ALTERED DATE

LOWEST_SCN NUMBER
Yes
MVL_OLDEST_RID NUMBER

MVL_OLDEST_PK NUMBER

MVL_OLDEST_OID NUMBER

MVL_OLDEST_NEW NUMBER

MVL_OLDEST_RID_TIME DATE

MVL_OLDEST_PK_TIME DATE

MVL_OLDEST_OID_TIME DATE

MVL_OLDEST_NEW_TIME DATE

MVL_BACKCOMPAT_VIEW VARCHAR2 (128)
MVL_PHYSMVL VARCHAR2 (128)
HIGHEST_SCN NUMBER

HIGHEST_TIMESTAMP DATE

Query Text

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


SELECT CTOBJ#
,      LOG_OWNER
,      LOG_NAME
,      LOG_OWNERID
,      CREATED_TIME
,      FILE_VERSION
,      USING_ROWID_FLAG
,      USING_PRIMARYKEY_FLAG
,      USING_OID_FLAG
,      USING_SEQUENCE_FLAG
,      CHANGE_SET_NAME
,      SOURCE_SCHEMA_NAME
,      SOURCE_TABLE_NAME
,      CREATED_SCN
,      MVL_FLAG
,      CAPTURED_VALUES
,      MVL_TEMP_LOG
,      MVL_V7TRIGGER
,      LAST_ALTERED
,      LOWEST_SCN
,      MVL_OLDEST_RID
,      MVL_OLDEST_PK
,      MVL_OLDEST_OID
,      MVL_OLDEST_NEW
,      MVL_OLDEST_RID_TIME
,      MVL_OLDEST_PK_TIME
,      MVL_OLDEST_OID_TIME
,      MVL_OLDEST_NEW_TIME
,      MVL_BACKCOMPAT_VIEW
,      MVL_PHYSMVL
,      HIGHEST_SCN
,      HIGHEST_TIMESTAMP
FROM SYS.EXU9MVL;

Dependencies

[top of page]

SYS.EXU9MVL references the following:

SchemaSYS
TableCDC_CHANGE_TABLES$
ViewSESSION_ROLES
TableUSER$
SYS.EXU9MVL is referenced by following:

SchemaSYS
ViewEXU9MVLU