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

15 votes167 views4 answers
How to get all tables in sql
SQL
0 vote160 views1 answer
How to get all values in a table mysql in c#
SQL
1 vote185 views1 answer
Spring postgresql reset auto increment to 0
SQL
22 votes166 views2 answers
Mysql show all tables
SQL
1 vote194 views1 answer
Oracle sql pad left zeros
SQL
0 vote182 views1 answer
Hotw to alter lengh character vayng postgres
SQL
0 vote183 views1 answer
Dbms_output sql developer
SQL
6 votes185 views3 answers
Date_trunc postgres
SQL
1 vote237 views2 answers
Begin transaction sql
SQL
28 votes175 views4 answers
Show tables mysql
SQL