/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

3 votes210 views1 answer
Unsigned int in mysql
SQL
0 vote198 views1 answer
Mysql concat and use as where column
SQL
0 vote206 views1 answer
C# execute transact sql
SQL
11 votes214 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
5 votes205 views1 answer
How to use rank function in sql
SQL
1 vote204 views1 answer
Add sequence postgres
SQL
0 vote211 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote207 views1 answer
Grepper sql workbench download
SQL
31 votes211 views4 answers
Mysql grant execute
SQL
0 vote222 views2 answers
Add colum in sql
SQL