Original ORA-01536 space limit beyond the table space ' xxxx '

1. Fault condition

Monday morning, the customer called, said the database space is full. Check the table space situation, there are remaining, check Alert_xxx.log also did not have an error.

Software side-by-hand test, execute insert data times error, as follows:

ORA-01536: Space limit beyond the table space ' xxxx '

2, fault resolution

Use the business user ' AA ' to log into the database and query the business user ' AA ' to the table space ' XXXX ' limit

SELECT * from User_ts_quotes;

The Max_bytes field is "0", indicating that the limit is exhausted and needs to be adjusted

Increase the user's read and write limit to the table space from the original 2.5G to 5G:

Alter user ' AA ' quota 5G on ' XXXX ';

3. Verification

After the software test, the database is used normally.

4. Summary

If you encounter a ORA-01536 error, first look at the user's tablespace limit
SELECT * from Dba_ts_quotas;
SELECT * from User_ts_quotas;

Max_bytes field-1 is a representation of No limit, the other value is how much.
Dba_ts_quotas: Describes limits for all user tablespace
User_ts_quotas: Describes the limit for the current user table space.

If the Max_bytes field in the query results is not-1, it is modified to an unrestricted or specified size.

Do not make tablespace quota control for users:
GRANT UNLIMITED tablespace Touser;

This approach is global in its own way. Or
Alter USER user quota unlimited on user_tablespace;
This approach is specific to the table space.

Reclaim table Space Limit control:
Revoke unlimited tablespace from user;

Or
Alter user user quota 0 on user_tablespace;

[Original] ORA-01536 exceeds tablespace ' xxxx ' space limit