/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 vote325 views1 answer
Knex last insert id mysql
SQL
-1 vote318 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
1 vote289 views1 answer
Alter user mysql native password
SQL
1 vote379 views1 answer
Oracle transaction rollback not working
SQL
9 votes349 views1 answer
No sql
SQL
1 vote316 views2 answers
Postgresql backup and restore globals and data
SQL
2 votes340 views1 answer
Mysql now format
SQL
0 vote323 views1 answer
How to find sql server name
SQL
42 votes439 views6 answers
Rename table sql server
SQL
25 votes339 views1 answer
Mysql grant all privileges to a user
SQL