A quota is the amount of space allocated to a user in a tablespace.
Change quota allocation
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