Oracle 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 vote445 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
1 vote188 views3 answers
Mysql disable foreign keys check
SQL
0 vote197 views1 answer
Exit psql
SQL
0 vote194 views3 answers
How to run sql query
SQL
0 vote197 views2 answers
Py sqlite if entry exists
SQL
0 vote197 views1 answer
Kill slow queries mysql
SQL
2 votes187 views2 answers
Created at and updated at in mysql
SQL
0 vote211 views1 answer
Sql last time database was accessed
SQL
0 vote193 views1 answer
One table with another
SQL
1 vote188 views1 answer
Postgresql convert text to float
SQL