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

VIEW: SYS.ALL_REPRESOL_STATS_CONTROL

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

Information about statistics collection for conflict resolutions for replicated tables which are accessible to the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
SNAME VARCHAR2 (128) Yes Owner of replicated object
ONAME VARCHAR2 (128) Yes Name of the replicated object
CREATED DATE
Yes Timestamp for which statistics collection was first started
STATUS VARCHAR2 (9)
Status of statistics collection: ACTIVE, CANCELLED
STATUS_UPDATE_DATE DATE
Yes Timestamp for which the status was last updated
PURGED_DATE DATE

Timestamp for the last purge of statistics data
LAST_PURGE_START_DATE DATE

The last start date of the statistics purging date range
LAST_PURGE_END_DATE DATE

The last end date of the statistics purging date range
Query Text

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


SELECT SNAME
,      ONAME
,      CREATED
,      STATUS
,      STATUS_UPDATE_DATE
,      PURGED_DATE
,      LAST_PURGE_START_DATE
,      LAST_PURGE_END_DATE
FROM SYS.ALL_REPRESOL_STATS_CONTROL;

Dependencies

[top of page]

SYS.ALL_REPRESOL_STATS_CONTROL references the following:

SchemaSYS
TableOBJ$
TableOBJAUTH$
TableUSER$
SchemaSYSTEM
TableREPCAT$_RESOL_STATS_CONTROL
SYS.ALL_REPRESOL_STATS_CONTROL is referenced by following:

SchemaPUBLIC
SynonymALL_REPRESOL_STATS_CONTROL