From Oracle FAQ
Jump to: navigation, search

A quota is the amount of space allocated to a user in a tablespace.

Change quota allocation[edit]

A user's quota can be changed with the ALTER USER command. Examples: Restrict user to 10M:

ALTER USER scott QUOTA 10M ON users;

Allow unlimited space:

ALTER USER scott QUOTA unlimited ON users;


Query the USER_TS_QUOTAS view to see the quota allocation.

SQL> SELECT * FROM user_ts_quotas;

Note: A quota value of -1 indicated UNLIMITED, meaning the user can use as much space in that tablespaces as he/she wants to.

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #