/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 vote197 views1 answer
Product of a column in mysql
SQL
0 vote246 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote180 views2 answers
Pl sql auto increment
SQL
0 vote192 views1 answer
Sql #region
SQL
0 vote176 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
22 votes190 views3 answers
SQL CHEATSHEET
SQL
0 vote203 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
12 votes182 views1 answer
Docker mysql random root password
SQL
0 vote183 views2 answers
Sql join on comma separated field
SQL
0 vote226 views2 answers
Sqlalchemy default value for column
SQL