/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 vote291 views1 answer
Where date major today mysql
SQL
0 vote282 views1 answer
Check if database exists sql
SQL
0 vote279 views1 answer
Mysql database hyphen
SQL
2 votes237 views4 answers
Mysql change database character set to utf8mb4
SQL
1 vote288 views1 answer
How to delete data from sql database in android
SQL
4 votes288 views1 answer
Id increment ms sql server
SQL
0 vote273 views1 answer
Mysql date time string format python
SQL
7 votes293 views3 answers
Convert ansi sql
SQL
0 vote233 views1 answer
Mysql convert column to uppercase
SQL
18 votes295 views3 answers
Mysql add column default value
SQL