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

VIEW: SYS.CDB_SYNC_CAPTURE_PREPARED_TABS

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

All tables prepared for synchronous capture instantiation in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
TABLE_OWNER VARCHAR2 (30) Yes Owner of the table prepared for synchronous capture instantiation
TABLE_NAME VARCHAR2 (30) Yes Name of the table prepared for synchronous capture instantiation
SCN NUMBER
Yes SCN from which changes can be captured
TIMESTAMP DATE

Time at which the table was ready to be instantiated
CON_ID NUMBER

container id
Query Text

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


SELECT TABLE_OWNER
,      TABLE_NAME
,      SCN
,      TIMESTAMP
,      CON_ID
FROM SYS.CDB_SYNC_CAPTURE_PREPARED_TABS;

Dependencies

[top of page]

SYS.CDB_SYNC_CAPTURE_PREPARED_TABS does not reference any database object

SYS.CDB_SYNC_CAPTURE_PREPARED_TABS is referenced by following:

SchemaPUBLIC
SynonymCDB_SYNC_CAPTURE_PREPARED_TABS