Here is a query to find users that have unlimited quota on a tablespace.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
select username,tablespace_name,max_bytes from dba_ts_quotas;If the max_bytes values is -1, that user has unlimited quota on the corresponding tablespace.