Oracle User Quota

Quota
A quota is the amount of space allocated to a user in a tablespace.
You may get oracle error like below due to this problem.
ORA-01536:space quota exceeded for tablespace 'string'


Change quota allocation
A user's quota can be changed with the ALTER USER command. Examples: Restrict user to 10M:
ALTER USER test QUOTA 10M ON users;


Allow unlimited space
ALTER USER test QUOTA unlimited ON users;


Monitor
Query the USER_TS_QUOTAS view to see the quota allocation.
SQL> SELECT * FROM user_ts_quotas;