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

0 vote147 views2 answers
Mysql cast to varchar
SQL
1 vote107 views2 answers
Sql select only row with the max date
SQL
0 vote99 views1 answer
How to fix mysql stop unexpectedly
SQL
16 votes104 views3 answers
Delete row psql
SQL
0 vote99 views1 answer
Connecting to my cloud sql server with c#
SQL
4 votes108 views1 answer
Postgresql create table with index
SQL
3 votes92 views1 answer
MySQL DELETE JOIN
SQL
0 vote131 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
5 votes60 views1 answer
Postgres upsert
SQL
1 vote108 views1 answer
Sql select row with max date
SQL