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

4 votes319 views2 answers
Sql table
SQL
0 vote306 views1 answer
Sql python hwo to pass a list in paramerter
SQL
2 votes312 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote326 views1 answer
Mysql query problems and solutions
SQL
2 votes324 views1 answer
Pandas to sql index
SQL
1 vote329 views2 answers
Test sqlsrv connection
SQL
10 votes358 views5 answers
Create table mysql query
SQL
1 vote306 views1 answer
Index a database column sql
SQL
4 votes395 views2 answers
Delete all table oracle
SQL
-1 vote339 views1 answer
How to change the auto increment in existing table mysql
SQL