The DELETE_TABLE_PREFS procedure deletes the statistics preferences of a table owned by 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 logon username is used by default. |
| tabname | The name of the table. |
| pname | The name of the preference. |
Exceptions
| Error code | Description |
|---|---|
| ORA-20000 | You do not have the required privilege. |
| ORA-20001 | Input values are invalid. |
Considerations
To call this procedure, you must connect to the database as the specified user or have the
SYSDBAprivilege.The parameters of this procedure are of the
VARCHAR2type and their values must be enclosed with parentheses.
Examples
Delete the preference DEGREE of the tbl1 table of the testUser01 user.
obclient> CALL DBMS_STATS.DELETE_TABLE_PREFS('testUser01', 'tbl1', 'DEGREE');
Query OK, 0 rows affected