/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

5 votes114 views1 answer
Mysql get last day of month
SQL
2 votes112 views1 answer
Oracle sql concatenate results into string
SQL
2 votes125 views1 answer
Mysql application.properties spring boot
SQL
0 vote114 views1 answer
Limit and offset in stored procedure mssql
SQL
1 vote122 views3 answers
What is union in sql
SQL
10 votes106 views1 answer
How to import database in mysql by cmd
SQL
0 vote110 views1 answer
Select password from user mysql
SQL
4 votes186 views1 answer
Oracle table statistics
SQL
1 vote119 views1 answer
Mysql query where in select
SQL
3 votes118 views1 answer
Sql cast to integer
SQL