/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

3 votes123 views1 answer
Sql timestamp to date
SQL
0 vote137 views2 answers
Psql commande \gset
SQL
0 vote134 views1 answer
How to list function in psql
SQL
5 votes130 views4 answers
Describe table postgres
SQL
0 vote196 views1 answer
Replace null value within column mysql
SQL
0 vote186 views1 answer
Oracle show running job
SQL
16 votes154 views1 answer
Mysql smallint range
SQL
0 vote135 views1 answer
Set default value now() date
SQL
0 vote153 views1 answer
Sql remove non numeric characters
SQL
0 vote136 views1 answer
Groupby sort sql hive
SQL