/SQL/Alter database datafile maxsize 32g

Alter database datafile maxsize 32g

SELECT * FROM DBA_DATA_FILES;

ALTER TABLESPACE my_tbs ADD DATAFILE '/path/to/my_file.dbf' 
	SIZE 100M AUTOEXTEND OFF;
-- Autoextend with max size:
ALTER TABLESPACE my_tbs ADD DATAFILE '/path/to/my_file.dbf' 
	SIZE 10G AUTOEXTEND ON NEXT 1G MAXSIZE 32G;    
-- For TEMP tablespaces:
ALTER TABLESPACE my_tbs ADD TEMPFILE '/path/to/my_file.dbf' 
	SIZE 100M AUTOEXTEND OFF;

Similar codes

0 vote171 views1 answer
Mysql update sequence with order by
SQL
1 vote188 views2 answers
Sql convert datetime to year month
SQL
0 vote215 views1 answer
Oracle chain step succeeded
SQL
0 vote192 views1 answer
Less mysql display
SQL
0 vote195 views1 answer
Get server date mysql
SQL
0 vote228 views1 answer
Concat column value of same user in mysql
SQL
0 vote215 views1 answer
Connect laravel to mysql on mac
SQL
1 vote201 views1 answer
Mysql strict_trans_tables
SQL
0 vote167 views1 answer
Get who is hired in month in sql
SQL
1 vote201 views1 answer
Mysql curdate between two dates
SQL