/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 vote67 views1 answer
Mysql find foreign key references
SQL
7 votes108 views4 answers
What is my mysql version
SQL
0 vote115 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote108 views1 answer
How to see the query of a view in mysql
SQL
1 vote131 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote111 views1 answer
Microsoft sql server python connection
SQL
13 votes106 views2 answers
Get date from now() mysql
SQL
9 votes135 views3 answers
Date format in sql
SQL
7 votes115 views2 answers
3rd height salary sql
SQL
0 vote113 views1 answer
Oracle get running queries
SQL