Can anybody give me the clariffication for the below queries?

[rajeshbalusu]

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

[LKBrwn_DBA]

Reading the fine Oracle® Database Concepts would answer all your questions.

[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.......

[PAVB]

Hope i answered ur questions

You certainly did -somehow.

On the other hand, issue here is that poster doesn't even know the difference in between dba_% and user_% systems views therefore until poster starts seriously reading the basic documentation it would be immaterial the amount of effort in supporting him.

Next question would probably be about the difference in between dba_tables and user_tables … get it?

People here volunteers time and effort in helping other people, we can pass the ball but poster has to show himself open and willing to carry it for a few yards getting a hit or two in the process; don’t you think so?

[chaitanyagoa]

U are absolutey right PAVB..... A little research before posting always helps