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 vote351 views1 answer
Drop function
SQL
3 votes344 views1 answer
Oracle revoke grant
SQL
0 vote342 views1 answer
Oracle free up space in tablespace
SQL
0 vote362 views1 answer
Update sql sintax
SQL
0 vote327 views2 answers
Android sqlite tutorial for beginners
SQL
3 votes354 views1 answer
Select database in sql
SQL
4 votes359 views1 answer
Alter session set nls_date_format
SQL
0 vote349 views1 answer
Sql server python connection
SQL
0 vote382 views1 answer
Create table in dbms cmds
SQL
5 votes375 views1 answer
Sql table columns
SQL