/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

1 vote311 views1 answer
Vagrant mysql downgrade version
SQL
0 vote295 views1 answer
Kotlin sqlite delete row
SQL
1 vote302 views1 answer
SQLite order random
SQL
2 votes268 views1 answer
Foreign key example in dbms
SQL
0 vote318 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote301 views1 answer
Alter database name script
SQL
0 vote298 views1 answer
Character count sql
SQL
0 vote294 views1 answer
C# datetime to sql server datetime
SQL
0 vote332 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
4 votes345 views1 answer
Mysql store ip address
SQL