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

4 votes272 views2 answers
Sql offset
SQL
1 vote279 views1 answer
How to select random rows from a table
SQL
0 vote267 views1 answer
Sql server query database space available
SQL
1 vote319 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote270 views1 answer
Sql composite key
SQL
-1 vote288 views1 answer
Create view in mysql workbench
SQL
1 vote286 views1 answer
How to set up a trigger in sql
SQL
-1 vote269 views1 answer
Mysql change database charset and collation
SQL
1 vote297 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote267 views1 answer
User defined variables in sql
SQL