oerr ora 1950 01950, 00000, "no privileges on tablespace '%s'" // *Cause: User does not have privileges to allocate an extent in the // specified tablespace. // *Action: Grant the user the appropriate system privileges or grant the user // space resource on the tablespace. 看一下用户U...
01950, 00000, "no privileges on tablespace '%s'" // *Cause: User does not have privileges to allocate an extent in the // specified tablespace. // *Action: Grant the user the appropriate system privileges or grant the user // space resource on the tablespace. 1. 2. 3. 4. 5. 6. ...
ORA-01950: no privileges on tablespace 'TBS_IDX' 这是怎么回事? 其实看一下IDX,就可以猜出来了,这张表一定是有索引,并且存储于TBS_IDX,而且用户对于TBS_IDX无使用权限, SQL> select index_name, table_name, tablespace_name from user_indexes WHERE table_na...
1.先查看报错用户所属的表空间,得到表空间名称 A select * fromuser_users; 2.使用表空间上一个有权限的用户给报错用户赋权 grantresourceto aaaareadonly; --赋权限 revokeresourcefrom aaaareadonly; --回收权限 3.再执行 insert into 操作,就可以了...