限制用户数

huayd_cu

 

SQL> select count(*) from dba_users;

  COUNT(*)
----------
 37

SQL> alter system set LICENSE_MAX_USERS=38;

System altered.

SQL> create user test1 identified by test1;

User created.

SQL> create user test2 identified by test1;
create user test2 identified by test1
                                *
ERROR at line 1:
ORA-01985: cannot create user as LICENSE_MAX_USERS parameter exceeded