quota tablespace oracle

Set tablespace quota to 10G for user

1. ALTER USER SCOTT QUOTA 10G ON USERS;

SELECT TABLESPACE_NAME,

BYTES / 1024 / 1024 "UTILIZIED_SPACE",

MAX_BYTES / 1024 / 1024 "QUOTA_ALLOCATED"

FROM dba_ts_quotas

WHERE username = 'SCOTT';