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 vote161 views1 answer
Select insert new table sql server
SQL
1 vote139 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
3 votes151 views1 answer
Oracle list privileges
SQL
0 vote149 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote157 views1 answer
How to save data in database in mysql node
SQL
0 vote151 views1 answer
Kill thread
SQL
0 vote157 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote194 views1 answer
Install squirrel sql ubuntu
SQL
1 vote162 views1 answer
Moodle query first user access
SQL
-1 vote148 views1 answer
Ssql to lowercqse
SQL