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 vote144 views1 answer
Sqlite3 now
SQL
37 votes197 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote168 views1 answer
To_date sql
SQL
3 votes191 views1 answer
Apex set debug level
SQL
3 votes251 views2 answers
Savepoint in sql
SQL
0 vote182 views1 answer
Select top values sql
SQL
0 vote166 views1 answer
Sql sum show 0 result
SQL
5 votes155 views1 answer
Ignore duplicate rows in sqlite
SQL
2 votes163 views2 answers
Create empty table from existing table
SQL
0 vote146 views1 answer
Mysql start of today
SQL