oracle 01536,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     quota   unlimited   on   PXTRG_D;

grant   unlimited   tablespace   to   ============

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

================