SELECT
s.source_name, s.dbid, s.logfile_location, s.logfile_suffix,
s.source_description, s.created,
decode(bitand(s.source_type, 206),
2, 'AUTOLOG',
4, 'HOTLOG',
8, 'SYNCHRONOUS',
68, 'DISTRIBUTED HOTLOG',
130, 'AUTOLOG ONLINE',
'UNKNOWN'),
s.source_database, s.first_scn, s.publisher,
s.capture_name, s.capqueue_name, s.capqueue_tabname,
s.source_enabled
FROM sys.cdc_change_sources$ s
SELECT
S.SOURCE_NAME
, S.DBID
, S.LOGFILE_LOCATION
, S.LOGFILE_SUFFIX
,
S.SOURCE_DESCRIPTION
, S.CREATED
,
DECODE(BITAND(S.SOURCE_TYPE
, 206)
,
2
, 'AUTOLOG'
,
4
, 'HOTLOG'
,
8
, 'SYNCHRONOUS'
,
68
, 'DISTRIBUTED HOTLOG'
,
130
, 'AUTOLOG ONLINE'
,
'UNKNOWN')
,
S.SOURCE_DATABASE
, S.FIRST_SCN
, S.PUBLISHER
,
S.CAPTURE_NAME
, S.CAPQUEUE_NAME
, S.CAPQUEUE_TABNAME
,
S.SOURCE_ENABLED
FROM SYS.CDC_CHANGE_SOURCES$ S
|
|
|