Can anybody give me the clariffication for the below queries?

[chaitanyagoa]

Hi,

SQL> select * from dba_ts_quotas;

TABLESPACE_NAME USERNAME BYTES MAX_BYTES BLOCKS MAX_BLOCKS DRO
------------------------------ ------------------------------ ---------- ---------- ---------- ---------- ---
KUMAR_DATA KUMAR 0 10485760 0 1280 NO

SQL> select * from user_ts_quotas;

TABLESPACE_NAME BYTES MAX_BYTES BLOCKS MAX_BLOCKS DRO
------------------------------ ---------- ---------- ---------- ---------- ---
KUMAR_DATA 0 0 0 0 NO

SQL>


What is the difference between the above two queries?

am confusing about the querry result.

Regards
Rajesh

Hi rajesh,

dba_ts_quotas query can be used only by people who have the DBA privilages. The user_ts_quotas is the query for the normal users.....

Hope i answered ur questions.......