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 vote421 views2 answers
Mysql insert rows to another database
SQL
6 votes377 views2 answers
Mysql concatenate two columns into one
SQL
1 vote342 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote343 views1 answer
Find most frequent value in SQL column
SQL
0 vote362 views1 answer
Oracle create job if not exists
SQL
3 votes363 views1 answer
Uppercase and lowercase in sql
SQL
37 votes447 views6 answers
Mysql update
SQL
4 votes338 views1 answer
Mysql insert from local csv
SQL
0 vote436 views1 answer
Intellij mysql set timezone
SQL
4 votes352 views2 answers
Show all database inside postgresql
SQL