Orphaned entries in DBA_TS_QUOTAS
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Orphaned entries in DBA_TS_QUOTAS

  1. #1
    Join Date
    Jan 2008
    Posts
    1

    Wink Orphaned entries in DBA_TS_QUOTAS

    It appears that after droping a tablespace the corresponding grants on that tablespace are not removed, so when I query DBA_TS_QUOTAS i see entires for tablespaces that have long been gone. When I try removing them via the 'ALTER USER XXXX QUOTA 0 ON XXXX' command I receive the message that the tablespace doesn't exist (which is correct; it has been dropped). SO , how do I remove the entries from TS_QUOTAS for tablespaces that have alreayd been dropped ? You would think these would be taken care of automatically when the tablespace was dropped...

  2. #2
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109
    First confirm if there are any users still having quotas on the dropped tablespace

    If yes remove them using

    Alter user quota 0 K on ;

    Seelan

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    does it really matter?

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