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 vote204 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
37 votes143 views3 answers
Postgresql insert column
SQL
0 vote137 views1 answer
Sql get month from date
SQL
1 vote170 views1 answer
Sql order by timestamp
SQL
0 vote152 views1 answer
Php get closest location by latitude longitude
SQL
1 vote160 views1 answer
Get parameter value in mysql trigger
SQL
1 vote153 views1 answer
How to set up a trigger in sql
SQL
6 votes136 views1 answer
Oracle list primary key
SQL
2 votes128 views2 answers
How to get capital letter first in sql
SQL
3 votes266 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL