Error: ORA 1536
Text: space quota exceeded for tablespace "<name>"
-------------------------------------------------------------------------------
Cause: The space quota in the tablespace is already used up and the operation
attempted the creation of a new extent in the tablespace.
Action: Either
Drop unnecessary objects in the tablespace to reclaim space.
Ask the database administrator to increase the tablespace quota.
该错误的处理方式：
The DBA must grant additional resource quota on the tablespace to that user.
One or all of the following may fix the problem:
1) Increase the tablespace quota allocated to that user by using the following command:
ALTER USER <user_name> QUOTA <integer> [K/M] ON <tablespace_name>
2) Grant unlimited quota to the user on that tablespace by using the following command:
ALTER USER <user_name> QUOTA UNLIMITED ON <tablespace_name>
If the problem occurs even after executing the above steps, then run the following command:
GRANT RESOURCE TO <user_name>
这个错误主要是由于表空间不足造成的，解决方法就是添加表空间大小
一般我喜欢这个解决方法：grant unlimited tablespace to username
unlimited tablespace 权限在移除dba权限时会被一起移除
标签：space,unlimited,quota,1536,tablespace,user,following From： https://blog.51cto.com/u_15812342/5738743