Re: Quota Question

From: Mserban <mserban_at_aol.com>
Date: 1997/04/09
Message-ID: <19970409042700.AAA11810@ladder01.news.aol.com>#1/1

Use ALTER USER <username> QUOTA <nnn>K(or M) ON <tablespace_name>;

Truncating user tables (or deleting from them) has nothing to do with a user's quota on a tablespace. A tablespace quota represents the total space allocated to all the objects (tables, indexes, clusters) a user can create in a tablespace, not the space the data take in those objects. It is a fixed value and can be altered only through the above SQL statement.

I believe the new quota will take effect the next time <username> logs into ORACLE.

I hope this helps.

Michael Serbanescu
Senior Consultant, MIACO Corporation Received on Wed Apr 09 1997 - 00:00:00 CDT