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

1 vote270 views2 answers
Mysql order by date asc null last
SQL
0 vote278 views1 answer
Get only structure database mysql
SQL
0 vote274 views1 answer
Call function sql oracle
SQL
2 votes280 views1 answer
Check isolation level in mysql
SQL
0 vote383 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote282 views1 answer
Setval postgres example table id
SQL
17 votes344 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote301 views1 answer
Login failed for user sql server
SQL
0 vote300 views2 answers
Sql count number of rows after group by
SQL
0 vote404 views5 answers
Right join
SQL