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 vote256 views1 answer
Oracle list index on table
SQL
0 vote291 views1 answer
Mysql zerofill
SQL
0 vote278 views1 answer
Create table sql generator
SQL
0 vote267 views1 answer
Mysql find db contarint
SQL
0 vote255 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote289 views1 answer
Uncheck constraints and delete from table
SQL
0 vote268 views3 answers
Insert or ignore postgres
SQL
6 votes267 views2 answers
Mysql set primary key
SQL
0 vote263 views2 answers
Sql server select first day of previous year
SQL
0 vote312 views1 answer
Stratified sampling sql
SQL