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