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

3 votes185 views1 answer
How to remove characters from string in mysql
SQL
0 vote200 views1 answer
Value of sold product using having and group by in sql
SQL
1 vote202 views1 answer
Table valued functions in sql
SQL
14 votes205 views3 answers
Oracle sql limit results
SQL
37 votes238 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
8 votes184 views1 answer
Oracle add months to sysdate
SQL
0 vote215 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
-1 vote197 views2 answers
First letter capital in mysql query
SQL
0 vote147 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote191 views1 answer
Sql offfset
SQL