/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

8 votes119 views1 answer
Oracle add auto_increment column to existing table
SQL
13 votes127 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
0 vote114 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote121 views1 answer
How to delete python anywhere mysql database
SQL
4 votes125 views1 answer
Id increment ms sql server
SQL
0 vote122 views1 answer
Import Data in MySQL without using any other software
SQL
4 votes161 views2 answers
Sql select except null
SQL
0 vote129 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
3 votes128 views1 answer
Increment integer in table sql
SQL
1 vote129 views1 answer
Add sequence postgres
SQL