/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 vote138 views1 answer
Get who is hired in month in sql
SQL
0 vote165 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote237 views1 answer
Site:av.ru "files"
SQL
0 vote161 views1 answer
Oracle exchange subpartition
SQL
0 vote163 views1 answer
Sql ignore
SQL
0 vote175 views1 answer
Leftjoin in sql
SQL
1 vote156 views1 answer
Alter add syntax
SQL
0 vote154 views1 answer
Postgresql combine values in one field
SQL
79 votes419 views6 answers
Grepper code
SQL
0 vote165 views1 answer
Import mysql'
SQL