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

0 vote272 views1 answer
Mysql with
SQL
0 vote281 views1 answer
Mysql max number not returning correct value
SQL
1 vote299 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
1 vote296 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote280 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
7 votes298 views3 answers
Select latest entry in sql table
SQL
14 votes299 views3 answers
Oracle sql limit results
SQL
5 votes300 views1 answer
Commentaire table oracle
SQL
0 vote310 views1 answer
Print boolean in plsql
SQL
1 vote314 views3 answers
Sql procedure
SQL