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

1 vote285 views7 answers
Filter
SQL
0 vote288 views1 answer
Suse status MySQL
SQL
-1 vote297 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
1 vote276 views2 answers
Mysql select tables with name like
SQL
0 vote308 views1 answer
Sqlalchemy _in array sqlite
SQL
3 votes280 views2 answers
Laravel tosql with bindings
SQL
0 vote282 views1 answer
Sql find all different values in column
SQL
0 vote272 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote263 views1 answer
Fix sqlite3 ruby on rails
SQL
1 vote255 views1 answer
Find logged in users mysql
SQL