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

3 votes150 views1 answer
Sql insert inserted id
SQL
3 votes159 views5 answers
No module named 'MySQLdb'
SQL
0 vote132 views1 answer
How to create an SQL save method in ruby
SQL
-1 vote137 views1 answer
How to format tables in sqlplus
SQL
1 vote156 views2 answers
Foreign key set 0
SQL
0 vote143 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote191 views1 answer
Call function sql oracle with output put line
SQL
19 votes142 views2 answers
Mysql add column after another
SQL
0 vote155 views1 answer
Oracle cpu metric
SQL
0 vote153 views1 answer
Mysql select where field is a value
SQL