The DROP_STAT_TABLE procedure is used to drop a user's information statistics table.
Syntax
DBMS_STATS.DROP_STAT_TABLE (
ownname VARCHAR2,
stattab VARCHAR2);
Parameters
Parameter |
Description |
|---|---|
| ownname | Username. If the username is set to NULL, the current login username will be used by default. |
| stattab | The name of the user statistics table to be dropped. |
Exceptions
Error code HY000 indicates that the table does not exist or you do not have sufficient privileges.
Usage instructions
You must have the privilege to drop the table in the specified schema to call this procedure.
Examples
Delete the statistics user table test_stat for user testUser01.
obclient> CALL DBMS_STATS.DROP_STAT_TABLE('testUser01', 'test_stat');
Query OK, 0 rows affected