CODE EXAMPLE FOR SQL

oracle limit user tablespace

SELECT * FROM DBA_TS_QUOTAS WHERE USERNAME='MY_USER';
ALTER USER my_user QUOTA 500M ON my_tablespace;		
ALTER USER my_user QUOTA UNLIMITED ON my_tablespace;