This Blog is also nick named as Oracle Slate, where we can chalk our experiences with Oracle Databases and related products of Oracle. This blog is very simple to understand and relatively useful for all the budding Oracle Dba's, Beginner Dba's, Dba's Under-Construction and
Experienced Dba's...
Sunday, July 10, 2011
User quotas on all tablespaces
col quota format a10
select username
, tablespace_name
, decode(max_bytes, -1, 'unlimited'
, ceil(max_bytes / 1024 / 1024) || 'M' ) "QUOTA"
from dba_ts_quotas
where tablespace_name not in ('TEMP')
/
No comments:
Post a Comment