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 votes131 views1 answer
Mysql where one year ago
SQL
-2 votes128 views1 answer
Group functions in sql
SQL
1 vote131 views2 answers
Reset mysqli fetch_arra
SQL
0 vote120 views1 answer
Sql compound operators
SQL
2 votes125 views1 answer
How to select first row of database sql
SQL
0 vote117 views1 answer
Sql server inner join convert collation
SQL
5 votes114 views1 answer
Oracle get nls settings
SQL
0 vote118 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
0 vote160 views1 answer
Mysql relationships between tables
SQL
8 votes115 views2 answers
Phpmyadmin password
SQL