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

6 votes225 views6 answers
Rename column postgres
SQL
1 vote200 views1 answer
Mysql get latest duplicate rows
SQL
0 vote185 views1 answer
Sql case sttement with set
SQL
-1 vote194 views1 answer
Default username and password for oracle 11g
SQL
0 vote195 views7 answers
10 random questions use python and SQL
SQL
8 votes232 views1 answer
Mac restore mysql database command line
SQL
1 vote180 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
22 votes186 views4 answers
Mysql date_format
SQL
0 vote213 views1 answer
Pl/pgsql declare variable
SQL
0 vote230 views1 answer
Error code 1215 cannot add foreign key constraint
SQL