user quota

[mary]

Please help me I am confused. I had am impression that if quota is unlimited it would show up as -1 in dba_ts_quotas. When I query dict_columns it says it would be null for both max_bytes and max_blocks.
SELECT * FROM DICT_COLUMNS
WHERE TABLE_NAME='DBA_TS_QUOTAS'

TABLE_NAME COLUMN_NAME COMMENTS
--------------- --------------- --------------------------------------------------
DBA_TS_QUOTAS TABLESPACE_NAME Tablespace name
DBA_TS_QUOTAS USERNAME User with resource rights on the tablespace
DBA_TS_QUOTAS BYTES Number of bytes charged to the user
DBA_TS_QUOTAS MAX_BYTES User's quota in bytes. NULL if no limit
DBA_TS_QUOTAS BLOCKS Number of ORACLE blocks charged to the user
DBA_TS_QUOTAS MAX_BLOCKS User's quota in ORACLE blocks. NULL if no limit

[sreddy]

Its showing up '-1'. May be descriptive purpose comments are like that . Verson is 815 .

TABLESPACE USERNAME BYTES MAX_BYTES BLOCKS MAX_BLOCKS
---------- ---------- --------- --------- --------- ----------
TOOLS SYSTEM 102522880 -1 25030 -1
TEMP SYSTEM 0 -1 0 -1
USERS SFAGO 0 -1 0 -1
USERS HELER 0 -1 0 -1
TEMP HLLER 0 -1 0 -1
USERS PROD 0 -1 0 -1
USERS NAV3 626688 -1 153 -1

[marist89]

hmmmm. I wonder if they are giving a distinction between UNLIMITED the value and NULL as an absence of a value?

[sreddy]

I think you are right! In the enterprise Manager it can be interpreted like this(infact, its showing..)

Unlimited..........for -1
None................for no quota