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

TABLE: APPLSYS.AD_ADOP_SESSIONS

Object Details
Object Name: AD_ADOP_SESSIONS
Object Type: TABLE
Owner: APPLSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000519938C00015$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
ADOP_SESSION_ID NUMBER
Yes
PREPARE_STATUS VARCHAR2 (1) Yes
APPLY_STATUS VARCHAR2 (1) Yes
FINALIZE_STATUS VARCHAR2 (1) Yes
CUTOVER_STATUS VARCHAR2 (1) Yes
CLEANUP_STATUS VARCHAR2 (1) Yes
ABORT_STATUS VARCHAR2 (1) Yes
STATUS VARCHAR2 (1) Yes
NODE_NAME VARCHAR2 (31)
NODE_TYPE VARCHAR2 (30)
APPLTOP_ID NUMBER

EDITION_NAME VARCHAR2 (30)
PID NUMBER

ABANDON_FLAG NUMBER

SESSION_INPUT_DATA CLOB (4000)
PREPARE_START_DATE DATE

PREPARE_END_DATE DATE

FINALIZE_START_DATE DATE

FINALIZE_END_DATE DATE

APPLY_START_DATE DATE

APPLY_END_DATE DATE

CUTOVER_START_DATE DATE

CUTOVER_END_DATE DATE

CLEANUP_START_DATE DATE

CLEANUP_END_DATE DATE

ABORT_START_DATE DATE

ABORT_END_DATE DATE

Query Text

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


SELECT ADOP_SESSION_ID
,      PREPARE_STATUS
,      APPLY_STATUS
,      FINALIZE_STATUS
,      CUTOVER_STATUS
,      CLEANUP_STATUS
,      ABORT_STATUS
,      STATUS
,      NODE_NAME
,      NODE_TYPE
,      APPLTOP_ID
,      EDITION_NAME
,      PID
,      ABANDON_FLAG
,      SESSION_INPUT_DATA
,      PREPARE_START_DATE
,      PREPARE_END_DATE
,      FINALIZE_START_DATE
,      FINALIZE_END_DATE
,      APPLY_START_DATE
,      APPLY_END_DATE
,      CUTOVER_START_DATE
,      CUTOVER_END_DATE
,      CLEANUP_START_DATE
,      CLEANUP_END_DATE
,      ABORT_START_DATE
,      ABORT_END_DATE
FROM APPLSYS.AD_ADOP_SESSIONS;

Dependencies

[top of page]

APPLSYS.AD_ADOP_SESSIONS does not reference any database object

APPLSYS.AD_ADOP_SESSIONS is referenced by following:

SchemaAPPLSYS
ViewAD_ADOP_SESSIONS#