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 vote345 views1 answer
Low level operator in dbms
SQL
0 vote359 views1 answer
Check if table exists oracle
SQL
0 vote371 views1 answer
How to to get time in sql
SQL
0 vote363 views1 answer
Const pool = mysql.createpool()
SQL
9 votes342 views2 answers
Default number in sql
SQL
3 votes498 views1 answer
How to get yesterday date in sql
SQL
0 vote375 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
4 votes358 views2 answers
Show all database inside postgresql
SQL
2 votes382 views2 answers
Mysql alter column default
SQL
8 votes337 views1 answer
Oracle find text in functions
SQL