/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 vote269 views1 answer
Groupby error in mysql
SQL
0 vote277 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
4 votes263 views1 answer
Wilayah indonesia sql
SQL
2 votes281 views2 answers
Postgres drop column if exists
SQL
0 vote311 views1 answer
Python mysql check if database exists
SQL
0 vote255 views1 answer
Access refused mysql xampp server
SQL
0 vote293 views1 answer
Nodejs sql get one to many relationship as array
SQL
8 votes292 views1 answer
My sql version
SQL
0 vote251 views1 answer
Sql server is not
SQL
11 votes295 views1 answer
Creating tables in sql with python
SQL