VIEW: SYS.DBA_TSM_SOURCE

Source

View Text - Preformatted

SELECT
  src_db_name,
  src_inst_name,
  src_inst_id,
  src_inst_start_time,
  sequence#,
  src_sid,
  src_serial#,
  decode(src_state,
          0,  'NONE',
          1,  'SELECTED',
          2,  'COMMITED SELECT',
          3,  'READY FOR PREPARE',
          4,  'PREPARED',
          5,  'READY FOR SWITCH',
          6,  'SWITCHED',
          7,  'FAILED',
          8,  'READY FOR STATE TRANSFER',
          9,  'IN STATE TRANSFER',
          10, 'END OF STATE TRANSFER',
          'UNKNOWN'),
  connect_string,
  src_start_time,
  cost,
  decode(failure_reason,
          0, 'None',
          1, 'Instance shutdown before migration',
          2, 'End of session before migration',
          3, 'Invalid OCI operation',
          4, 'OCI Server Attach',
          5, 'OCI logon',
          6, 'OCI logoff',
          7, 'OCI disconnect',
          8, 'Invalid client state',
          9, 'End of migration',
         10, 'Session migration',
         11, 'Prepare from client failed',
         12, 'Session became non-migratable',
          NULL, '',
          'Unknown'),
  src_end_time,
  roundtrips,
  u1.name,
  u2.name,
  dst_db_name
FROM tsm_src$, user$ u1, user$ u2
WHERE
     (src_userid   = u1.user#)
 AND (src_schemaid = u2.user#)

View Text - HTML Formatted

SELECT SRC_DB_NAME
, SRC_INST_NAME
, SRC_INST_ID
, SRC_INST_START_TIME
, SEQUENCE#
, SRC_SID
, SRC_SERIAL#
, DECODE(SRC_STATE
, 0
, 'NONE'
, 1
, 'SELECTED'
, 2
, 'COMMITED SELECT'
, 3
, 'READY FOR PREPARE'
, 4
, 'PREPARED'
, 5
, 'READY FOR SWITCH'
, 6
, 'SWITCHED'
, 7
, 'FAILED'
, 8
, 'READY FOR STATE TRANSFER'
, 9
, 'IN STATE TRANSFER'
, 10
, 'END OF STATE TRANSFER'
, 'UNKNOWN')
, CONNECT_STRING
, SRC_START_TIME
, COST
, DECODE(FAILURE_REASON
, 0
, 'NONE'
, 1
, 'INSTANCE SHUTDOWN BEFORE MIGRATION'
, 2
, 'END OF SESSION BEFORE MIGRATION'
, 3
, 'INVALID OCI OPERATION'
, 4
, 'OCI SERVER ATTACH'
, 5
, 'OCI LOGON'
, 6
, 'OCI LOGOFF'
, 7
, 'OCI DISCONNECT'
, 8
, 'INVALID CLIENT STATE'
, 9
, 'END OF MIGRATION'
, 10
, 'SESSION MIGRATION'
, 11
, 'PREPARE
FROM CLIENT FAILED'
, 12
, 'SESSION BECAME NON-MIGRATABLE'
, NULL
, ''
, 'UNKNOWN')
, SRC_END_TIME
, ROUNDTRIPS
, U1.NAME
, U2.NAME
, DST_DB_NAME FROM TSM_SRC$
, USER$ U1
, USER$ U2 WHERE (SRC_USERID = U1.USER#)
AND (SRC_SCHEMAID = U2.USER#)