DELETE_TABLE_PREFS

The DELETE_TABLE_PREFS procedure deletes the statistics preference of a table that belongs to the specified user.

Syntax

DBMS_STATS.DELETE_TABLE_PREFS (
  ownname    IN  VARCHAR2,
  tabname    IN  VARCHAR2,
  pname      IN  VARCHAR2);

Parameters

Parameter	Description
ownname	The username. If the username is set to NULL, the current login username will be used by default.
tabname	The table name.
pname	The name of the preference.

Exceptions

Error Code	Description
HY000	Insufficient privileges. Invalid value or illegal input value.

Usage

• To run this procedure, you must connect to the database as the specified user.

• All parameters in this procedure are of the VARCHAR2 type, and their values must be enclosed in quotes.

Examples

Delete the DEGREE preference of the tbl1 table for the testUser01 user.

CALL DBMS_STATS.DELETE_TABLE_PREFS('testUser01', 'tbl1', 'DEGREE');
Query OK, 0 rows affected