DROP_STAT_TABLE

The DROP_STAT_TABLE procedure is used to drop the statistics table of a user.

Syntax

DBMS_STATS.DROP_STAT_TABLE (
  ownname VARCHAR2,
  stattab VARCHAR2);

Parameters

Parameter	Description
ownname	The username. If NULL is specified, the current login username is used.
stattab	The name of the statistics table of the user to be dropped.

Exceptions

Error code HY000 indicates that the table does not exist or the user does not have the required permissions.

Usage

You must have the permission to drop the table in the specified schema.

Examples

Drop the statistics table test_stat of the user testUser01.

CALL DBMS_STATS.DROP_STAT_TABLE('testUser01', 'test_stat');
Query OK, 0 rows affected