search

yuanrui / blog

Some notes.
http://yuanrui.github.io
3 stars 0 forks source link

ORA-01950: 对表空间'XXX'无权限问题, 解决办法 #36

Open yuanrui opened 3 years ago

yuanrui commented 3 years ago

查询用户(ADMIN)当前的默认表空间。 SELECT USERNAME, DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME = 'ADMIN';

SQL> SELECT USERNAME, DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME = 'ADMIN';

USERNAME
                                                 DEFAULT_TABLESPACE
--------------------------------------------------------------------------------
------------------------------------------------ ------------------------------
ADMIN
                                                 XXX_DB

对查询到的表空间(XXX_DB)不做配额限制 ALTER USER ADMIN QUOTA UNLIMITED ON XXX_DB;