unlimited tablespace and dba_ts_quotas dynamic view
sgalaxyJul 20 2006 — edited Jul 20 2006Hi everybody,
I have read an article about the dba_ts_quotas and particularly the following query :
select username, tablespace_name,
bytes/1024/1024 used,
max_bytes/1024/1024 quota
from dba_ts_quotas
order by username
which returns for each user and its tablespace the used tablespace and quota (size in the tablespace which can host user's objects).
In the article , it is pointed out that if a user has unlimited tablespace on the tablespace then the column quota has the value of -0.000 , whereas in my database (oracle 10g v.2 on XP) the value -9,5367431 appears!!!!
What may be the reason ...the different database versions????
However the value -9,5367431 seems to be like 'irrelevant'.......
Thanks , a lot
Simon