Oracle create 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 vote180 views1 answer
Sql script get all stored procedures from database
SQL
1 vote205 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote199 views1 answer
Codeigniter dbforge add index
SQL
0 vote210 views1 answer
Sql query to force the database to be drop
SQL
0 vote202 views1 answer
Sql server user permissions and roles
SQL
0 vote201 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote210 views1 answer
Database traccar
SQL
1 vote209 views1 answer
Install postgresql on raspberry pi
SQL
0 vote206 views1 answer
Search column name sql
SQL
5 votes178 views1 answer
Mongodb vs
SQL