Selecting tablespace quotas

Hi,

I'm using Release 8.1.7 on Win NT 4.0.

Does anyone know why a user's tablespace quota won't show up in DBA_TS_QUOTAS, but it will in USER_TS_QUOTAS? I logged in as SYS and did the following:

sys_at_oratdb.trinidat> select tablespace_name, username, bytes, max_bytes   2 from dba_ts_quotas
  3 order by 1,2
  4 /

TABLESPACE_NAME USERNAME BYTES MAX_BYTES

-------------------- ---------- ---------- ----------
FDB_TBLSP_IDX01      FDB         125583360         -1
FDB_TBLSPIMPORTLOBS  FDB           1228800         -1
FDB_TBLSP01          STORA       142565376         -1
FDB_TBLSP01          STORA_OLD   146849792         -1
TDB_TBLSPINDEX       ADB          16629760         -1
TDB_TBLSPLOBS        ADB           3670016         -1
TDB_TBLSPLOBS        TDB          67633152         -1
TDB_TBLSP01          ADB           4194304         -1
TOOLS                SPOTLIGHT      163840         -1

I expected to see a quota on TDB_TBLSP01 for the user 'SIZER'. I then logged on as SIZER and selected from USER_TS_QUOTAS:

sys_at_oratdb.trinidat> @connect sizer/******@oratdb Connect durchgeführt.
sizer_at_oratdb.trinidat> select tablespace_name, bytes, max_bytes   2 from user_ts_quotas
  3 order by 1
  4 /

TABLESPACE_NAME BYTES MAX_BYTES

-------------------- ---------- ----------
SYSTEM                        0          0
TDB_TBLSP01            29753344          0

This really had me fooled because SIZER couldn't extend a tablespace (ORA-01536) and DBA_TS_QUOTAS wouldn't tell me why. I also noticed that DBA_TS_QUOTAS doesn't show me the quotas on SYSTEM, and that DBA_TS_QUOTAS is only showing me unlimited quotas. wtf?

Thanks,
Tom Received on Mon May 13 2002 - 11:00:23 CDT