/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

4 votes354 views3 answers
Employee name starting with in sql
SQL
0 vote347 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote341 views2 answers
Getting customers with no orders sql
SQL
0 vote351 views1 answer
Mariadb select limit offset
SQL
0 vote356 views1 answer
Adding generated time in row mysql workbench
SQL
0 vote356 views1 answer
Automated psql csv export script on windows
SQL
1 vote388 views3 answers
Epoch to datetime
SQL
1 vote336 views1 answer
Oracle case
SQL
0 vote344 views1 answer
Which MySQL data type to use for storing boolean values
SQL
10 votes343 views4 answers
Sql pagination
SQL