/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 vote170 views1 answer
Alter owner in PostgreSQL
SQL
4 votes151 views2 answers
Oracle set date format
SQL
0 vote175 views3 answers
ChAnge TABLE name apex oracle
SQL
4 votes174 views4 answers
Start mysql
SQL
0 vote164 views1 answer
Copied text from internet not inserting in mysql
SQL
-2 votes188 views1 answer
Trunc in sql
SQL
0 vote170 views1 answer
Select only one row sql
SQL
0 vote178 views1 answer
How to query without duplicate rows in sql
SQL
1 vote184 views1 answer
Too many connections mysql
SQL
0 vote173 views1 answer
Normalization in database 2nd normal form
SQL