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


VIEW: SYS.DBA_SYNC_CAPTURE_TABLES

Object Details
Object Name: DBA_SYNC_CAPTURE_TABLES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All tables that are captured by synchronous streams captures.

[View Source]

Columns
Name Datatype Length Mandatory Comments
TABLE_OWNER VARCHAR2 (128)
Owner of the sync capture table
TABLE_NAME VARCHAR2 (128)
Name of the sync capture table
ENABLED VARCHAR2 (3)
Is synchronous Streams capture enabled for this table?
Query Text

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


SELECT TABLE_OWNER
,      TABLE_NAME
,      ENABLED
FROM SYS.DBA_SYNC_CAPTURE_TABLES;

Dependencies

[top of page]

SYS.DBA_SYNC_CAPTURE_TABLES references the following:

SchemaSYS
ViewDBA_STREAMS_TABLE_RULES
TableOBJ$
TableTAB$
TableUSER$
SYS.DBA_SYNC_CAPTURE_TABLES is referenced by following:

SchemaPUBLIC
SynonymDBA_SYNC_CAPTURE_TABLES