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 vote140 views1 answer
Char varchar nvarchar sql
SQL
2 votes152 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote150 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote155 views1 answer
Get max salary from each department sql
SQL
1 vote140 views1 answer
Psql datetime grather than
SQL
2 votes141 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote137 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
0 vote151 views1 answer
Trigger stock phpmyadmin output message
SQL
1 vote160 views2 answers
Drop table if exists test
SQL
8 votes101 views2 answers
Alter column name in mssql
SQL