VIEW: SYS.USER_TS_QUOTAS

Source

View Text - Preformatted

select ts.name, spc.blocks * ts.blocksize,
       decode(spc.maxblocks, -1, -1, spc.maxblocks * ts.blocksize),
       spc.blocks, spc.maxblocks, decode(ts.online$, 3, 'YES', 'NO')
from sys.ts$ ts, sys.tbs_space_usage spc
where spc.tsn = ts.ts#
  and spc.user# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT TS.NAME
, SPC.BLOCKS * TS.BLOCKSIZE
, DECODE(SPC.MAXBLOCKS
, -1
, -1
, SPC.MAXBLOCKS * TS.BLOCKSIZE)
, SPC.BLOCKS
, SPC.MAXBLOCKS
, DECODE(TS.ONLINE$
, 3
, 'YES'
, 'NO') FROM SYS.TS$ TS
, SYS.TBS_SPACE_USAGE SPC WHERE SPC.TSN = TS.TS#
AND SPC.USER# = USERENV('SCHEMAID')