/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 vote204 views1 answer
Mysql récupérer le code création de vue
SQL
2 votes187 views1 answer
Sql server find table name
SQL
0 vote204 views1 answer
Code to move ietms from one table to another myswl
SQL
0 vote207 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote194 views1 answer
Turnicate in mysql
SQL
3 votes211 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
1 vote188 views1 answer
Mysql select another database
SQL
0 vote192 views1 answer
First Step in installing SQL workbench
SQL
0 vote193 views1 answer
Mysql config slave
SQL
0 vote180 views1 answer
Wordpress sql find and replace
SQL