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