DBA Hub

📋Steps in this guide1/2

QUOTA in Tablespace

For Example:

oracle configurationintermediate
by OracleDba
13 views
1

Overview

- To assign a quota to a user, you use the statement. For example: For Example: - To remove a quota, set the quota to or use the keyword to allow unlimited usage:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
ALTER USER username QUOTA size ON tablespace_name;

ALTER USER PDBUSER QUOTA 500M ON users;

ALTER USER username QUOTA 0 ON tablespace_name;
-- or
ALTER USER username QUOTA UNLIMITED ON tablespace_name;
2

Section 2

For Example: - You can view quota information using data dictionary views such as . For Example:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
ALTER USER PDBUSER QUOTA 0 ON users;

SELECT tablespace_name, username, bytes, max_bytes
FROM dba_ts_quotas
WHERE username = 'USERNAME';

SELECT tablespace_name, username, bytes, max_bytes
FROM dba_ts_quotas
WHERE username = 'PDBUSER'
;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!