Pages
(Move to ...)
Home
Legal
Info
HowTos
Code
Publications
Music
Finance
Links
Comics
Donate
▼
19/04/2014
[Oracle] Get user's tablespace quota
To check the current quota status for user's tablespaces, run this query on
DBA_TS_QUOTAS
:
SELECT tablespace_name, username, ROUND(bytes/1024/1024) MB, ROUND(max_bytes/1024/1024) MAX_MB
FROM dba_ts_quotas;
remembering that you will need the grants to access it
No comments:
Post a Comment
With great power comes great responsibility
‹
›
Home
View web version
No comments:
Post a Comment
With great power comes great responsibility