/SQL/Script to add datafile to tablespace

Script to add datafile to tablespace

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

1 vote184 views3 answers
Rows, INSERT INTO
SQL
16 votes227 views3 answers
Order by sql query
SQL
36 votes188 views3 answers
Add column in mysq
SQL
0 vote198 views2 answers
What is the default password for sql server sa
SQL
0 vote184 views1 answer
Mssql dockere
SQL
3 votes264 views2 answers
Savepoint in sql
SQL
0 vote179 views2 answers
Homebrew nysql launch
SQL
4 votes176 views1 answer
Group by mysql and concatenate string
SQL
3 votes185 views4 answers
Truncate syntax in sql
SQL
42 votes247 views6 answers
Sql query duplicate rows
SQL