/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 vote248 views1 answer
Oracle db list usernames
SQL
0 vote257 views1 answer
Postgres get running query
SQL
7 votes363 views2 answers
3rd height salary sql
SQL
0 vote307 views1 answer
000webhost database values insert
SQL
0 vote300 views1 answer
Delete duplicate rows
SQL
0 vote292 views1 answer
Select into table variable
SQL
1 vote303 views1 answer
Age postgres
SQL
7 votes291 views2 answers
Mysql get year from date
SQL
1 vote288 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote300 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL