Oracle space quota exceeded -- ORA-01536

In one of my support case,I get error like " java.sql.SQLException: ORA-01536: space quota exceeded for tablespace 'PXTRG_D' "

The cause of ORA-01536 is that the space quota for the segment owner in the tablespace has been exhausted and the operation attempted the creation of a new segment extent in the tablespace.

The action is that either drop unnecessary objects in the tablespace to reclaim space or have a privileged user increase the quota on this tablespace for the segment owner.

You can increase the quota on the tablespace as follows:

alter   user   <username>  quota   unlimited   on   PXTRG_D;
grant   unlimited   tablespace   to   <username>


============
select * from dba_role_privs where GRANTEE= 'username' ; //check the user's role
select * from dba_sys_privs where GRANTEE= 'username' ; // check the  privilege
SELECT * FROM DBA_TS_QUOTAS; // list all tablespace quotas
================