ora-01950 no privileges on tablespasce TESTDATA 错误解决办法

报错信息：

ora-01950noprivilegeson tablespasce TESTDATA

SQL>insert into tab01(aa)values('sdf');

insert into tab01(aa)values('sdf')

           *

ERRORat line1:

ORA-0195:noprivilegesontablespace'TESTDATA'

问题:没有分配表空间配额:

解决办法：

SQL> conn /assysdba;

Connected.

SQL>alteruser test01 quota50Mon TESTDATA;

User altered.

SQL>

SQL>insertinto tab01(aa)values('sdfsd');

1row created.

SQL>