Oracle tablespace quota

Table space quota Overview

Oracle
The official website defines quota as follows: a limit on a resource, such as a limit on the amount
Database storage used by a database user. A database administrator can
Set tablespace quotas for each Oracle database username
For more information about Oracle quota, see the official Oracle documentation.

Http://download.oracle.com/docs/cd/E11882_01/network.112/e16543

Routine Quota Management

FAQs

ORA-01536: space quota exceeded for table space 'cyyd'
Solution:
Alter User Username quota 100 m on tablespacename;
Alter User Username quota unlimited on tablespacename;
Grant unlimited tablespace to username;
Quota is designed to restrict the use of table space. For example, you can restrict the use of guotu in tablespace.
The quota in cyyd is 10 M. When the data volume of guotu in tablespace cyyd reaches 10 m, regardless of your tablespace
How much space does cyyd have, and guotu cannot use tablespace cyyd any more.
So you need:
Alter user aguotu quota 1000 m on cyyd;
Alter user guotu quota unlimited on cyyd;
Grant unlimited tablespace to guotu

Dba_ts_quotas

The data dictionary view related to quota is the condition of dba_ts_quotasjava-javascript wind