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 vote241 views1 answer
Sql convert float to string
SQL
3 votes225 views3 answers
Docker create postgresql database
SQL
3 votes206 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote222 views1 answer
Sql select min row
SQL
1 vote148 views1 answer
Postgres reset auto increment
SQL
0 vote190 views1 answer
Django how to get query result count
SQL
3 votes185 views3 answers
Concatenation in sql
SQL
1 vote195 views1 answer
Sql bitwise operators
SQL
0 vote245 views1 answer
Datagrip exec
SQL
0 vote238 views1 answer
Select 1 from orders
SQL