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 vote326 views1 answer
Sql server datetime
SQL
0 vote333 views1 answer
Mysql loop through databases and execute query
SQL
0 vote338 views1 answer
Multiple like values for single column postgres
SQL
0 vote325 views1 answer
Sql get month from date
SQL
0 vote361 views1 answer
Insert using condition postgres
SQL
0 vote316 views1 answer
We are intrested to work with your organization
SQL
0 vote316 views1 answer
Sql insert tuple
SQL
1 vote332 views1 answer
Drop function
SQL
10 votes323 views1 answer
Oracle all_dependencies
SQL
6 votes306 views1 answer
Sqlite foreign key
SQL