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

0 vote282 views1 answer
Sql trim whitespace
SQL
1 vote242 views3 answers
Getdate function in postgresql
SQL
1 vote219 views2 answers
Difference between in and between in sql
SQL
1 vote216 views3 answers
Mysql Server Start
SQL
0 vote247 views1 answer
ORA-00942
SQL
0 vote290 views1 answer
Mysql, how to query the table comments?
SQL
1 vote240 views1 answer
Create new table in SQL from old table with data
SQL
1 vote241 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote236 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote194 views1 answer
Import csv to mysql
SQL