DBA Hub

📋Steps in this guide1/1

Tablespace quota for a user

-- 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';

oracle configurationintermediate
by OracleDba
18 views
1

Tablespace quota for a user

-- 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'; --- Change the tablespace quota for the user to 5G --- Grant unlimited tablespace quota:

Code/Command (click line numbers to comment):

1
2
3
4
5
TABLESPACE_NAME                                 UTILIZIED_SPACE                  QUOTA_ALLOCATED
------------------------------         ---------------------------        --------------------------
USERS                                           .0625                                    1024
ALTER USER SCOTT QUOTA 5G ON USERS;
ALTER USER SCOTT QUOTA UNLIMITED ON USERS;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!