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 vote215 views1 answer
Delete from table where length sql
SQL
0 vote172 views1 answer
Sql select most frequent value in column
SQL
2 votes160 views1 answer
Sql update alias
SQL
0 vote149 views1 answer
Sub blocks in sql
SQL
10 votes163 views4 answers
Primary key in sql
SQL
0 vote159 views1 answer
How to print out column name differently in mysql
SQL
6 votes178 views2 answers
Foreign key sqlite3 python
SQL
0 vote175 views1 answer
Delete hangfire retries list
SQL
6 votes167 views1 answer
Oracle trigger after connect
SQL
1 vote276 views1 answer
Concat first name and last name in mysql
SQL