http://www.oradba.ch/2011/04/find-user-with-unlimited-tablespace-quota/ col tablespace_name for a20 col username for a30 SELECT tablespace_name, username, round(bytes/1024/1024) "MB", case max_bytes when -1 then 'UNLIMITED' end "MAX_BYTES" FROM dba_ts_quotas WHERE max_bytes = -1 order by 1, 2; _____________________________________________________________________________________ drop user hajo cascade; drop tablespace hajo including contents and datafiles; -- TABLESPACE create tablespace hajo logging datafile size 50m; -- USER create user hajo identified by hajo default tablespace hajo temporary tablespace temp account unlock; -- QUOTAS alter user hajo quota unlimited on hajo; select tablespace_name, bytes, max_bytes, blocks, max_blocks, dropped from dba_ts_quotas where username = 'HAJO'; alter user hajo quota 500m on hajo; select tablespace_name, bytes, max_bytes, blocks, max_blocks, dropped from dba_ts_quotas where username = 'HAJO'; select tablespace_name, case max_bytes when -1 then 'UNLIMITED' end from dba_ts_quotas where username = 'HAJO'; drop user hajo cascade; drop tablespace hajo including contents and datafiles;