DBA Data[Home] [Help]

VIEW: SYS.DBA_SUBSCRIPTIONS

Source

View Text - Preformatted

SELECT
   s.handle, s.set_name, s.username, s.created, s.status, s.earliest_scn,
   s.latest_scn, s.description, s.last_purged, s.last_extended,
   s.subscription_name
  FROM sys.cdc_subscribers$ s
View Text - HTML Formatted

SELECT S.HANDLE
, S.SET_NAME
, S.USERNAME
, S.CREATED
, S.STATUS
, S.EARLIEST_SCN
, S.LATEST_SCN
, S.DESCRIPTION
, S.LAST_PURGED
, S.LAST_EXTENDED
, S.SUBSCRIPTION_NAME
FROM SYS.CDC_SUBSCRIBERS$ S