Oracle add datafile to tablespace

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 vote377 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote367 views1 answer
Group by join columns per table
SQL
5 votes346 views1 answer
Migrate sql table another database
SQL
2 votes344 views3 answers
Mysql list tables by size
SQL
0 vote373 views1 answer
Connect laravel to mysql on mac
SQL
1 vote444 views1 answer
Mysql get max value and id
SQL
0 vote342 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
-1 vote345 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
1 vote372 views1 answer
Sql server: query to find out all the places where the table is used
SQL
2 votes351 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL