Re: Can not remove quota on dropped tablespace.

From: Kenneth Koenraadt <plovmand_at_hotmail.com>
Date: Sun, 29 Jul 2001 10:09:50 GMT
Message-ID: <3b63dfff.2000217@news.mobilixnet.dk>

On Sat, 28 Jul 2001 20:45:21 GMT, "Ethan Post" <Blah_at_Blah.com> wrote:

>User shows unlimited quota in OEM on tablespace that I dropped. 8.1.7 AIX
>4.3.3. My guess is recreate the tablespace then remove quota. Anyone got a
>better idea. If it uses an object ID I don't suppose that will work.
>
>- Ethan
>- http://www.FreeTechnicalTraining.com
>- http://www.geocities.com/epost1
>
>
>

Hi Ethan,

Tablespace quotas cannot be revoked once created. The best you can do is to reduce the quota to 0M.

Since the tablespace is dropped, you should not worry, unless some administrator re-creates the tablespace. For that sake, you should reduce the quota to 0M on the tablespace for all users, though is is actually dropped.

Regards,
Kenneth Koenraadt
Systems Consultant
Oracle DBA
plovmand@<no-spam>hotmail.com Received on Sun Jul 29 2001 - 05:09:50 CDT