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

1 vote249 views1 answer
SQL server query column yes or no
SQL
3 votes252 views4 answers
Order by desc postgres
SQL
0 vote261 views1 answer
Postgresql comandos basicos
SQL
0 vote243 views1 answer
How to insert same table data using mysql query
SQL
2 votes248 views1 answer
Mariadb select multiple rows into one column
SQL
2 votes266 views1 answer
Sql server: select column values as comma separated string
SQL
16 votes326 views2 answers
Sql vs nosql
SQL
1 vote282 views1 answer
Sql set auto increment back to 0
SQL
0 vote266 views1 answer
Oracle sql count occurrences of value in column
SQL
12 votes242 views1 answer
Create column sql server
SQL