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 vote284 views1 answer
DATEDIFF minute postgres
SQL
11 votes262 views2 answers
Set default column value sql
SQL
0 vote319 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote270 views1 answer
Mysql terminal run sql file
SQL
0 vote266 views1 answer
Mysql update set sum
SQL
2 votes296 views2 answers
Create table mysql integer NOT null
SQL
1 vote268 views1 answer
Get table column names sql ssms
SQL
9 votes291 views3 answers
Find all tables with column name
SQL
0 vote262 views1 answer
Set mysql socket file docker windows
SQL
0 vote249 views2 answers
Mysql slave status
SQL