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

6 votes119 views2 answers
Clear a table in mysql
SQL
8 votes113 views1 answer
Sql limit results returned
SQL
6 votes145 views2 answers
Subtr Oracle ?
SQL
0 vote112 views2 answers
Sql if empty then
SQL
11 votes117 views2 answers
Having in sql
SQL
0 vote115 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
0 vote120 views1 answer
Execut sql python
SQL
2 votes117 views1 answer
Postgresql transaction
SQL
0 vote115 views3 answers
Mysqli count down
SQL
1 vote117 views1 answer
Postgresql if 0 then 1
SQL