Hi
I was under impression if I specify "QUOTA 100M ON USERS" while create a user, the user would not be allowed to have more than 100MB data in the schema (on tablespace USERS) and will get an error ORA-01536 when he exceeds.
But I have seen at least 2 uses in my database where the user has crossed the quota.
select q.username, q.bytes/1024/1024 consumed_mb, q.max_bytes/1024/1024 allowed_mb
from dba_ts_quotas q
where q.bytes>q.max_bytes and Q.MAX_BYTES <> -1
order by 1;
Shows
USERNAME CONSUMED_MB ALLOWED_MB
------------------------------ ----------- ----------
USER_ONE 173.0625 100
USER_TEN 1177 100
I am using Oracle XE 11g on CentOS.
I will be thankful if someone can help me fix the limits.
Regards,
Habib