Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.CANCEL_STATISTICS

Purpose

To stop collecting statistics about the successful resolution of update, uniqueness, and delete conflicts for a table. For additional information, refer to

Syntax

The parameters for the CANCEL_STATISTICS procedure are described in Table 12 - 86, and the exceptions are listed in Table 12 - 87. The syntax for this procedure is shown below:

DBMS_REPCAT.CANCEL_STATISTICS(	sname	IN	VARCHAR2,
					oname	IN	VARCHAR2)

Parameter Description
sname The name of the schema in which the table is located.
oname The name of the table for which you do not want to gather conflict resolution statistics.

Table 12 - 86. Parameters for CANCEL_STATISTICS

Exception Description
missingschema The given schema does not exist.
missingobject The given table does not exist.
statnotreg The given table is not currently registered to collect statistics.

Table 12 - 87. Exceptions for CANCEL_STATISTICS

Parameter	Description
`sname`	The name of the schema in which the table is located.
`oname`	The name of the table for which you do not want to gather conflict resolution statistics.

Exception	Description
missingschema	The given schema does not exist.
missingobject	The given table does not exist.
statnotreg	The given table is not currently registered to collect statistics.