SQL> alter user oracle identified by 123456;
alter user oracle identified by 123456
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
原因:在表空间“USERS”无权限
解决办法:
用户登录,查看当前用户所属表空间:select username,default_tablespace from dba_users;
修改表空间:alter user username quota umlimited on tablespacename;
或者 grant resource to username 也可以
因为 grant resource to username 时 自动获得了有unlimited tablespace的系统权限