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

53 votes563 views6 answers
How to install mysql ubuntu
SQL
0 vote169 views1 answer
Sql change date format
SQL
0 vote198 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote202 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote235 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote171 views1 answer
SAP Return
SQL
0 vote166 views1 answer
Como saber si tengo mysql instalado
SQL
13 votes183 views5 answers
Sql default
SQL
2 votes224 views1 answer
Mariadb json select
SQL
0 vote234 views1 answer
Alter database name script
SQL