What DBA view shows users' tablespace quotas?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: What DBA view shows users' tablespace quotas?

Hybrid View

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    What DBA view shows users' tablespace quotas?

    A user in the states has a problem with a system on his laptop. ORA-01536 - space quota exceeded for SYSTEM tablespace.
    I suspect that the user he is connecting as has a default tablespace of SYSTEM. Where can I check what his users' space quota is for this tablespace?
    (And yes, I'll get him to alter the user's default TBS to something other than SYSTEM.)

  2. #2
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234
    SQL> select table_name from dict where table_name like '%QUOT%';

    TABLE_NAME
    ------------------------------
    DBA_TS_QUOTAS
    USER_TS_QUOTAS

    Tycho

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