Alter tablespace add datafile

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

4 votes352 views2 answers
Linq join
SQL
0 vote371 views1 answer
Sql update subtract value
SQL
1 vote396 views3 answers
How to reset id column in sql server
SQL
0 vote338 views1 answer
Sql server select top 2 of each group
SQL
6 votes352 views2 answers
Postgresql restore from dump
SQL
8 votes326 views1 answer
Oracle find text in functions
SQL
0 vote331 views2 answers
Update all linkedserver tables with openquery on db
SQL
-1 vote338 views1 answer
Io
SQL
0 vote342 views1 answer
Export partttion and import in oracle
SQL
3 votes349 views3 answers
C# sql select
SQL