-
Can anybody give me the clariffication for the below queries?
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
-
Oracle 101
Reading the fine Oracle® Database Concepts would answer all your questions.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Originally Posted by 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
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.......
-
Originally Posted by chaitanyagoa
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?
Last edited by PAVB; 08-05-2009 at 10:33 AM.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Hello...
U are absolutey right PAVB..... A little research before posting always helps
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|