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 vote126 views1 answer
Pl/sql how to delete a trigger
SQL
1 vote135 views1 answer
Convert epoch to date in sql server
SQL
2 votes132 views1 answer
Oracle index size
SQL
0 vote120 views1 answer
Create date sql
SQL
0 vote129 views1 answer
Sum sqlserver
SQL
1 vote127 views1 answer
What is in condition in sql
SQL
0 vote128 views1 answer
Sql revert migration
SQL
9 votes139 views3 answers
Find all tables with column name
SQL
1 vote174 views1 answer
Select last row from SQL Table
SQL
0 vote136 views1 answer
Datagrip execute procedure
SQL