/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 vote193 views1 answer
Get date ISO in psql
SQL
6 votes179 views2 answers
Where clause in sql
SQL
0 vote179 views1 answer
Order by ip address sql
SQL
0 vote176 views1 answer
Update set with inner join oracle
SQL
0 vote177 views1 answer
Mysql query with sql to get the next row
SQL
0 vote171 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote188 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote181 views1 answer
Mysql could not fetch tables
SQL
3 votes184 views2 answers
Enter mysql command line
SQL
14 votes180 views3 answers
Sql trim from string
SQL