/SQL/Alter tablespace add datafile autoextend

Alter tablespace add datafile autoextend

SELECT * FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'my_tbs' ORDER BY FILE_NAME;

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 32000M;    
-- For TEMP tablespace:
ALTER TABLESPACE my_tbs ADD TEMPFILE '/path/to/my_file.dbf' 
	SIZE 100M AUTOEXTEND OFF;

Source: dba-oracle.com

Similar codes

5 votes222 views3 answers
Db begintransaction laravel
SQL
1 vote230 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
0 vote216 views1 answer
Mysql coonect sample code
SQL
0 vote236 views1 answer
Sparql if bound query
SQL
0 vote220 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote214 views1 answer
Syntax for changing column size in mysql
SQL
0 vote207 views1 answer
Sql server remove enter from string
SQL
5 votes197 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote200 views1 answer
Rabbitmq service not starting
SQL
2 votes217 views1 answer
Brew start postgres manual
SQL