/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 vote151 views2 answers
Replace null with 0 in sql
SQL
0 vote145 views4 answers
Best data type to represent money in mysql
SQL
0 vote137 views1 answer
Sql quary intervewi question
SQL
0 vote140 views1 answer
Db format in quotation
SQL
0 vote186 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
1 vote168 views2 answers
How to add amount between date in sql
SQL
0 vote144 views1 answer
Pl sql round
SQL
5 votes162 views2 answers
Oracle list columns
SQL
0 vote155 views1 answer
Postgresql inline table
SQL
2 votes147 views1 answer
Mysql time ago difference
SQL