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 vote353 views1 answer
Get from database the most recent data limit by 5
SQL
18 votes362 views6 answers
Laravel form validation
SQL
1 vote322 views1 answer
Select random sample sql
SQL
1 vote382 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
1 vote356 views1 answer
Postgres check for foreign key
SQL
0 vote436 views1 answer
Redshift running queries
SQL
0 vote343 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
4 votes337 views2 answers
Oracle unliock account
SQL
2 votes421 views1 answer
Find column in all stored procedures sql server
SQL
0 vote351 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL