Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.PURGE_STATISTICS

Purpose

To remove information from the RepResolution_Statistics view. For additional information, refer to

Syntax

The parameters for the PURGE_STATISTICS procedure are described in Table 12 - 153, and the exceptions are listed in Table 12 - 154. The syntax for this procedure is shown below:

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

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

Table 12 - 153. Parameters for PURGE_STATISTICS

Exception Description
missingschema The given schema does not exist.
missingobject The given table does not exist.

Table 12 - 154. Exceptions for PURGE_STATISTICS

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

Exception	Description
missingschema	The given schema does not exist.
missingobject	The given table does not exist.