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

7 votes229 views3 answers
Foreign key oracle
SQL
15 votes237 views4 answers
Mysql export database command line
SQL
13 votes250 views5 answers
Alter table query sql server change column
SQL
5 votes242 views3 answers
Mysql remove unique constraint
SQL
0 vote220 views1 answer
Sql get table last modified time
SQL
1 vote252 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote221 views1 answer
Automatically update database last seen datetime in sql
SQL
1 vote251 views2 answers
Drop table with constraints
SQL
-1 vote233 views1 answer
How to change the auto increment in existing table mysql
SQL
3 votes248 views5 answers
Foreign keys
SQL