/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

9 votes268 views6 answers
Sql add column with default value
SQL
0 vote307 views1 answer
How to get table id sequence postgres
SQL
3 votes253 views1 answer
Pl sql check if variable is empty
SQL
13 votes267 views5 answers
Select last row mysql
SQL
10 votes274 views2 answers
Linux command line import mysql database
SQL
1 vote292 views1 answer
Store select query result in variable sql server
SQL
0 vote278 views1 answer
Drush run sql select
SQL
8 votes289 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
1 vote344 views1 answer
Mysql get max value and id
SQL
0 vote302 views1 answer
Check database restore status sql script
SQL