Oracle datafile max size 32gb

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

1 vote196 views1 answer
Oracle rolling back
SQL
0 vote223 views1 answer
Suhaib
SQL
3 votes224 views1 answer
Mysql insert on dupèlicate
SQL
0 vote203 views2 answers
Sql update top 100
SQL
1 vote205 views1 answer
Get all db sizes in mysql server
SQL
2 votes196 views1 answer
Sql count having
SQL
1 vote238 views2 answers
Sql split string by space
SQL
0 vote197 views1 answer
Oracle index hint
SQL
0 vote222 views1 answer
Sql gather statistics to increase performance
SQL
0 vote201 views1 answer
Sql convert datetime to year
SQL