The DELETE_SCHEMA_PREFS procedure deletes a statistics preference for all tables of the specified user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_STATS.DELETE_SCHEMA_PREFS (
ownname IN VARCHAR2,
pname IN VARCHAR2);
Parameters
| Parameter | Description |
|---|---|
| ownname | The name of the user. If the username is set to NULL, the current logon username is used by default. |
| pname | The name of the preference. |
Exceptions
| Error code | Description |
|---|---|
| ORA-20000 | The user does not exist, or you do not have the required privileges. |
| 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 DEGREE preference for the tables of the hr user.
obclient> CALL DBMS_STATS.DELETE_SCHEMA_PREFS('hr', 'DEGREE');
Query OK, 0 rows affected