DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Can anybody give me the clariffication for the below queries?

  1. #1
    Join Date
    May 2008
    Posts
    23

    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

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    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

  3. #3
    Join Date
    Jan 2008
    Posts
    45
    Quote Originally Posted by rajeshbalusu View Post
    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.......

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by chaitanyagoa View Post
    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.

  5. #5
    Join Date
    Jan 2008
    Posts
    45

    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
  •  


Click Here to Expand Forum to Full Width