/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

2 votes109 views1 answer
Mysql clear screen
SQL
0 vote106 views1 answer
Sql cheetsheet
SQL
0 vote143 views1 answer
Mysql grant access to one database
SQL
7 votes113 views5 answers
Sql remove spaces
SQL
0 vote123 views1 answer
Postgres get database encoding
SQL
0 vote70 views1 answer
Mysql timeout 30 seconds
SQL
0 vote107 views1 answer
Get primary key of table
SQL
0 vote106 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote129 views1 answer
Select count concat string sql server
SQL
0 vote104 views1 answer
Gcloud check sql
SQL