/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 vote315 views1 answer
Mysql workbench view
SQL
0 vote305 views1 answer
SQL isnumeric DB2
SQL
0 vote341 views4 answers
Sql rownum
SQL
0 vote336 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote324 views1 answer
How to set sql_mode for a query in CI model
SQL
1 vote299 views1 answer
Sql only five first row
SQL
2 votes354 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote293 views1 answer
What is the essence of SQL?
SQL
1 vote303 views1 answer
Convert rows to string sql server
SQL
0 vote307 views1 answer
Get records in sql according to month name and count
SQL