revoke tablespace quota - How ?

alter user quota statment grants quota on a tablespace to specified user. How do I revoke quota on a tablespace ?

Setting quota to 0 bytes is not good enough because record for the tablespace remains in dba_ts_quotas for the tablespace - EVEN AFTER YOU DROP THE TABLESPACE. This creates problem if you export this database and try to import it on another machine where alter user statements fail because tablespace dropped previously is not in the exp file and does not get created (it's gone) but import tries to alter user to grant quota on the tablespace that's gone ?????

Shouldn'd dropping tablespace remove quota on it for all users who were granted quota on it ? If not that, shouldn't oracle at least let me revoke quota manually before dropping tablespace ? What am I missing ? Received on Thu Jan 15 1998 - 00:00:00 CST