/SQL/Alter database datafile maxsize 32g

Alter database datafile maxsize 32g

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 vote308 views1 answer
Create table sql generator
SQL
0 vote334 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote288 views1 answer
Mysql update sequence with order by
SQL
0 vote316 views1 answer
Psql generate id in existing database
SQL
12 votes306 views1 answer
Script to add new column in table sql
SQL
1 vote324 views1 answer
Oracle sequence last_number
SQL
3 votes323 views1 answer
Mysql insert on dupèlicate
SQL
3 votes331 views2 answers
Check data in table mysql
SQL
0 vote310 views1 answer
Get sum sqlite android
SQL
1 vote317 views1 answer
Update mysql centos
SQL