Quota
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
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;
Monitor
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 | # |
