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 vote226 views1 answer
How to select all fieldsin a soql query
SQL
1 vote199 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote214 views1 answer
Enable full text search mysql
SQL
3 votes230 views1 answer
Sql print all names that start with a given letter
SQL
0 vote223 views1 answer
Regex any word except sql
SQL
2 votes231 views2 answers
Mysql search for column name in all tables
SQL
-1 vote230 views1 answer
Mysql order by on condition
SQL
0 vote228 views1 answer
Selecting duplicates
SQL
0 vote216 views1 answer
Mysql search multiple tables
SQL
0 vote225 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL