/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 vote215 views1 answer
Download sql file of countries names
SQL
0 vote158 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote239 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote157 views1 answer
Default value false mysql
SQL
0 vote150 views1 answer
Order by with where clause in mysql
SQL
0 vote153 views1 answer
Mysql drop multiple tables at once
SQL
-2 votes158 views1 answer
Create trigger syntax
SQL
0 vote172 views1 answer
Mysql min value row
SQL
0 vote158 views1 answer
No suitable driver found for sqlite
SQL
1 vote169 views3 answers
Union in sql
SQL