Replication Management API Reference, 99 of 179

PURGE_STATISTICS procedure

This procedure removes information from the DBA_REPRESOLUTION_STATISTICS view.

DBMS_REPCAT.PURGE_STATISTICS (
   sname      IN   VARCHAR2, 
   oname      IN   VARCHAR2, 
   start_date IN   DATE,
   end_date   IN   DATE);

Parameter	Description
sname	Name of the schema in which the replicated table is located.
oname	Name of the table whose conflict resolution statistics you want to purge.
start_date/end_date	Range of dates for which you want to purge statistics. If `START_DATE` is `NULL`, then purge all statistics up to the `END_DATE`. If `END_DATE` is `NULL`, then purge all statistics after the `START_DATE`.

Exception	Description
missingschema	Specified schema does not exist.
missingobject	Specified table does not exist.
statnotreg	Table not registered to collect statistics.