扩大该用户的表空间配额
SQL> select tablespace_name,username,max_bytes from DBA_TS_QUOTAS where username='WANG';
TABLESPACE_NAME USERNAME MAX_BYTES
------------------------------ ------------------------------ ----------
MEETING WANG 1073741824
DATAS WANG 1073741824
SQL> select tablespace_name,username,max_bytes/1024/1024/1024 from DBA_TS_QUOTAS where username='WANG';
TABLESPACE_NAME USERNAME MAX_BYTES/1024/1024/1024
------------------------------ ------------------------------ ------------------------
MEETING WANG 1
DATAS WANG 1
SQL> alter user WANG quota 2G on DATAS;
用户已更改。
SQL> select tablespace_name,username,max_bytes/1024/1024/1024 max_G from DBA_TS_QUOTAS where username='WANG';
TABLESPACE_NAME USERNAME MAX_G
------------------------------ ------------------------------ ----------
MEETING WANG 1
DATAS WANG 2