/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 vote368 views1 answer
Traccar mysql
SQL
0 vote363 views1 answer
Use mysql in java program
SQL
6 votes322 views2 answers
Join vs union
SQL
1 vote321 views1 answer
Set all the vluses in calumn in sql to false
SQL
21 votes351 views5 answers
Oracle all tables
SQL
0 vote313 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
2 votes370 views2 answers
Mysql write into table
SQL
0 vote303 views1 answer
Html css mobile menu arrow dropdown
SQL
2 votes329 views1 answer
Sql update \
SQL
1 vote342 views1 answer
How to delay stored procedure execution in sql server
SQL