/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

11 votes364 views2 answers
How to import mysql database command line
SQL
0 vote365 views1 answer
Change permission to database mysql
SQL
17 votes342 views4 answers
Sort by mysql
SQL
0 vote324 views1 answer
Power query case when
SQL
1 vote320 views1 answer
Mysql select month and year
SQL
1 vote326 views1 answer
Postgres delete from where date is greater than specific date
SQL
0 vote291 views0 answer
SQL
0 vote365 views1 answer
Postgres meta command to show all rows in table
SQL
4 votes350 views3 answers
Sql drop database if exists
SQL
0 vote340 views2 answers
Advantages of stored procedures sql
SQL