Find users who have unlimited quota on a tablespace

Here is a query to find users that have unlimited quota on a tablespace.

Here is a query to find users that have unlimited quota on a tablespace.

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.


This was first published in August 2003
This Content Component encountered an error

PRO+

Content

Find more PRO+ content and other member only offers, here.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close