Tablespace quota for a user - oracle database script

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;