Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: revoke tablespace quota - How ?
Hi,
We just found out that we had quota on our users that we didn't know
about at all.
Somehow it seems to be possible to create users with implicit quota.
We created them at version 7.0.1 without giving quota i think.
At the moment we're at 7.2.3 and a few weeks ago we got space quota
exceeded.
Oracle siad it's possible to use a version 6 syntax wich creates users
with implicit
quotas.
Look at the view text of dba_ts_quotas and user_quotas and you'll see
different selections ! We got rid of the quotas by giving the users
explicetedly
unlimited quotas (we only have a few major users) and i think that
should solve it
for a export in your case as well.
Jeroen
Nuno Souto wrote:
>
>
>
>
> 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
>> ?
>
>
>
> Shouldn't you be getting rid of the users that are defaulted to the
> non-existing tablespace? TSQ$ requires a tablespace and a user
> reference. You take away the tablespace, you should change the default
> for any user defaulted to it, ain't it?
>
> HTH
>
> Cheers
> Nuno Souto
> nsouto_at_acay.com.au
Received on Tue Jan 20 1998 - 00:00:00 CST