/SQL/Script to add datafile to tablespace

Script to 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 vote254 views1 answer
Sql how to get courses that i have made prerequisites
SQL
6 votes238 views1 answer
Postgres get size of database
SQL
2 votes237 views1 answer
Date conversion in mysql column
SQL
1 vote250 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
13 votes256 views4 answers
Mysql remove foreign key constraint
SQL
0 vote248 views1 answer
How to alter length character varying postgres
SQL
0 vote248 views1 answer
Postgresql in vs any performance
SQL
24 votes247 views5 answers
Import dump mysql
SQL
3 votes231 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote226 views1 answer
On update current_timestamp jpa
SQL