ORA-01536: space quota exceeded for tablespace ‘USERS’ | space quota exceeded for tablespace

First check table space quota for all user or for specific user using sql query.

DBA_TS_QUOTAS describes tablespace quotas for all users.
USER_TS_QUOTAS describes tablespace quotas for the current user.

select * from user_ts_quotas;
select * from dba_ts_quotas;

In result you can check MAX_BYTES – User’s quota in bytes, or -1 if no limit. If you want your user have no restrictions on the amount of data it puts in USERS, run:

ALTER USER <your user> quota unlimited on USERS;

or if you want to limit the quota to, say, 10 MB:

ALTER USER <your user> quota 10M on USERS;

Leave a Reply