ORA-01536：超出表空间XXXX的空间限额

本文主要是介绍ORA-01536：超出表空间XXXX的空间限额，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

扩大该用户的表空间配额

SQL> select tablespace_name,username,max_bytes from  DBA_TS_QUOTAS where username='WANG';TABLESPACE_NAME            USERNAME                MAX_BYTES
------------------------------ ------------------------------ ----------
MEETING                WANG                  1073741824
DATAS                  WANG                  1073741824SQL> 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                             1SQL> 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

这篇关于ORA-01536：超出表空间XXXX的空间限额的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---