select pt.table_owner, pt.table_name, pt.scn, pt.timestamp,
pt.supplemental_log_data_pk, pt.supplemental_log_data_ui,
pt.supplemental_log_data_fk, pt.supplemental_log_data_all
from all_tables at, dba_capture_prepared_tables pt
where pt.table_name = at.table_name
and pt.table_owner = at.owner
SELECT PT.TABLE_OWNER
, PT.TABLE_NAME
, PT.SCN
, PT.TIMESTAMP
,
PT.SUPPLEMENTAL_LOG_DATA_PK
, PT.SUPPLEMENTAL_LOG_DATA_UI
,
PT.SUPPLEMENTAL_LOG_DATA_FK
, PT.SUPPLEMENTAL_LOG_DATA_ALL
FROM ALL_TABLES AT
, DBA_CAPTURE_PREPARED_TABLES PT
WHERE PT.TABLE_NAME = AT.TABLE_NAME
AND PT.TABLE_OWNER = AT.OWNER
|
|
|