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

5 votes182 views1 answer
Oracle nls session
SQL
0 vote170 views1 answer
Plsql find location of procedure
SQL
1 vote175 views1 answer
Events mysql
SQL
7 votes178 views1 answer
Xampp reset mysql
SQL
1 vote179 views1 answer
Update foreign key value in mysql
SQL
1 vote184 views1 answer
Postgresql if 0 then 1
SQL
3 votes166 views2 answers
How to list columns for particular tables in postgresql
SQL
4 votes177 views1 answer
Datepart postgres
SQL
0 vote176 views1 answer
Sql sum show 0 result
SQL
0 vote171 views1 answer
Sql query to select records entered in last 24 hours
SQL