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

0 vote398 views1 answer
Pgadmin save data greyed out
SQL
2 votes352 views1 answer
Pandas to sql index
SQL
0 vote374 views1 answer
Mysql wait_timeout
SQL
0 vote338 views2 answers
Mysql updating multiple column values from array variable
SQL
7 votes356 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote366 views1 answer
Oracle tablespace autoextend
SQL
0 vote318 views1 answer
Oracle list all stored procedures
SQL
1 vote365 views1 answer
Oracle select row max date
SQL
2 votes378 views2 answers
Postgresql search all tables for column name
SQL
15 votes472 views5 answers
Select all tables sql
SQL