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 vote292 views1 answer
Codeigniter dbforge add index
SQL
0 vote291 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote296 views1 answer
Oracle allow space to user
SQL
1 vote297 views2 answers
Mysql: command not found
SQL
-1 vote345 views1 answer
Add 10 to all numbers in a column sql
SQL
2 votes308 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
6 votes313 views2 answers
What is non relational database
SQL
0 vote323 views5 answers
Mode sql course
SQL
0 vote287 views1 answer
Drop all data from tables
SQL
22 votes329 views3 answers
Year format in date mysql
SQL