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 vote155 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote126 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote111 views2 answers
Clear window pl sql
SQL
8 votes119 views1 answer
Oracle tablespace datafile max size
SQL
0 vote124 views1 answer
Neo4j command to run script file
SQL
24 votes122 views4 answers
Postgres remove database
SQL
3 votes115 views2 answers
Monthname sql
SQL
14 votes116 views4 answers
Remove record from table sql
SQL
0 vote112 views1 answer
How to check if there is no database schema
SQL
1 vote108 views1 answer
Check constraint to check if date greater than todays date
SQL