SET_SCHEMA_PREFS

The SET_SCHEMA_PREFS procedure is used to set the statistics preferences for a specified schema.

Syntax

DBMS_STATS.SET_SCHEMA_PREFS (
  ownname   IN   VARCHAR2,
  pname     IN   VARCHAR2,
  pvalue    IN   VARCHAR2);

Parameters

Parameter	Description
ownname	The name of the schema.
pname	The name of the preferences.
pvalue	The value of the preferences.

Exceptions

Error Code	Description
HY000	The object does not exist or the user does not have sufficient privileges. Invalid value or illegal input value.

Usage

• To execute this procedure, you must connect as the specified user.

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

Examples

CALL DBMS_STATS.SET_SCHEMA_PREFS('hr', 'DEGREE','10');
Query OK, 0 rows affected