Re: revoke tablespace quota - How ?

I am not sure if you want to revoke the quota completely. Otherwise, you can give a mimimal quota on that tablespace to the user, using the same command.

Amit
Oracle DBA

Sameer Utrankar wrote:

> 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