Tablespace quota for a user - Oracle Database Script. -- Get the current tablespace quota information of an user set lines 299 select TABLESPACE_NAME,BYTES/1024/1024 "UTILIZIED_SPACE" ,MAX_BYTES/1024/1024 "QUOTA_ALLOCATED" from dba_ts_quotas where username='&USER_NAME'; TABLESPACE_NAME UTILIZIED_SPACE QUOTA_ALLOCATED ------------------------------ --------------------------- -------------------------- USERS .0625 1024 --- Change the tablespace quota for the user to 5G ALTER USER SCOTT QUOTA 5G ON USERS; --- Grant unlimited tablespace quota: ALTER USER SCOTT QUOTA UNLIMITED ON USERS;
-- Get the current tablespace quota information of an user set lines 299 select TABLESPACE_NAME,BYTES/1024/1024 "UTILIZIED_SPACE" ,MAX_BYTES/1024/1024 "QUOTA_ALLOCATED" from dba_ts_quotas where username='&USER_NAME'; TABLESPACE_NAME UTILIZIED_SPACE QUOTA_ALLOCATED ------------------------------ --------------------------- -------------------------- USERS .0625 1024 --- Change the tablespace quota for the user to 5G ALTER USER SCOTT QUOTA 5G ON USERS; --- Grant unlimited tablespace quota: ALTER USER SCOTT QUOTA UNLIMITED ON USERS;