Revoke Quota on Tablespace from User

Revoke Tablespace Quota

In previous post, we have talked about how to set quota on tablespace for users. Now, let's see how to revert it.

1. Specific Tablespace

To turn quota off, just use 0 to revoke its usage on the tablespace.

SQL> alter user erpapp quota 0 on erpapp_tbs_01;

User altered.

To check the result, we perform a query on DBA_TS_QUOTAS.

SQL> select * from dba_ts_quotas where username = 'ERPAPP' and tablespace_name = 'USERS';

no rows selected

The quota has gone.

2. All Tablespace

SQL> revoke unlimited tablespace from erpapp;

Revoke succeeded.