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

34 votes131 views6 answers
Sql change data type
SQL
6 votes143 views3 answers
Commit in sql
SQL
1 vote161 views1 answer
Count of tables in database mysql
SQL
0 vote133 views1 answer
Mysql search multiple tables
SQL
1 vote155 views2 answers
Sql queries practice
SQL
0 vote151 views1 answer
Show table structure mysql console
SQL
3 votes131 views1 answer
Two selects in one query
SQL
0 vote131 views1 answer
Sql get month from date
SQL
0 vote148 views1 answer
Creating a simple notify in postgresql
SQL
0 vote160 views1 answer
How to get data from 2 database
SQL