UNLOCK_PARTITION_STATS

The UNLOCK_PARTITION_STATS procedure is used to unlock the statistics of a partition.

Syntax

DBMS_STATS.UNLOCK_PARTITION_STATS (
  ownname      VARCHAR2,
  tabname      VARCHAR2,
  partname     VARCHAR2);

Parameters

Parameter	Description
ownname	The username. If the username is set to NULL, the current login username is used by default.
tabname	The table name.
partname	The name of the (sub)partition.

Usage notes

You must be the owner of the table to call this procedure.

Examples

Unlock the statistics of the p0 partition of the t1 table in the testUser01 user.

CALL DBMS_STATS.UNLOCK_PARTITION_STATS ('testUser01', 't1', 'p0');
Query OK, 0 rows affected