Error : ORA-01536

Issue: ORA-01536: Space quota exceeded for tablespace 'USERS'

Metalink ID:General SQL Error. ORA-01536: Space Quota Exceeded For Tablespace 'XXXXX_XXXX' [ID 892973.1]

Action:  ALTER USER scott QUOTA UNLIMITED ON USERS;

Cause:quota exceeded

After allocating space please run below query.

select username, tablespace_name, max_bytes from dba_ts_quotas where username='SCOTT';

It should return a value of -1 for MAX_BYTES which indicates unlimited tablespace