The DELETE_SCHEMA_PREFS procedure deletes the statistics preferences for all tables in the specified schema.
Syntax
DBMS_STATS.DELETE_SCHEMA_PREFS (
ownname IN VARCHAR2,
pname IN VARCHAR2);
Parameters
| Parameter | Description |
|---|---|
| ownname | The name of the schema. |
| pname | The name of the preference. |
Exceptions
| Error code | Description |
|---|---|
| HY000 | The schema does not exist, you do not have the required privileges, or the input value is 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 in the hr schema.
obclient> CALL DBMS_STATS.DELETE_SCHEMA_PREFS('hr', 'DEGREE');
Query OK, 0 rows affected