Oracle user quota on tablespace

SELECT * FROM DBA_TS_QUOTAS WHERE USERNAME='MY_USER';
ALTER USER my_user QUOTA 500M ON my_tablespace;		
ALTER USER my_user QUOTA UNLIMITED ON my_tablespace;

Similar codes

3 votes177 views3 answers
Concatenation in sql
SQL
0 vote241 views1 answer
Oracle swap partition
SQL
2 votes179 views1 answer
Sql create database
SQL
0 vote203 views1 answer
Oracle winter time change
SQL
0 vote213 views2 answers
How to combine two sql queries in one result
SQL
1 vote204 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote192 views1 answer
What does leave do in mysql
SQL
49 votes268 views6 answers
Get duplicate records in sql
SQL
1 vote176 views1 answer
Substr sql last character
SQL
12 votes189 views4 answers
Mysql version query
SQL