Friday, December 20, 2013

ORA-00068

This example, tested on an Oracle 9 database, shows the largest permitted value for the max_enabled_roles parameter:

SQL> alter system set max_enabled_roles = 150 scope = spfile
  2  /
alter system set max_enabled_roles = 150 scope = spfile
*
ERROR at line 1:
ORA-00068: invalid value 150 for parameter max_enabled_roles, must be between 1 and 148

SQL> alter system set max_enabled_roles = 148 scope = spfile
  2  /

System altered.

SQL>

No comments: