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

2 votes185 views1 answer
Rails execute sql
SQL
0 vote193 views1 answer
Mysql_error replacement
SQL
0 vote199 views1 answer
Raiserror with nowait
SQL
3 votes190 views2 answers
Update Query in SQL Server
SQL
0 vote186 views1 answer
Mysql set column equal to another automatic
SQL
1 vote184 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
5 votes182 views1 answer
Postgres integer to serial
SQL
2 votes193 views1 answer
Mariadb JSON_EXTRACT
SQL
1 vote179 views1 answer
Error code 1175 mysql fix
SQL
6 votes193 views2 answers
Postgresql restore from dump
SQL