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

8 votes167 views2 answers
Change name of colum in sql table
SQL
0 vote182 views4 answers
Open mysql port bitnami tomact
SQL
0 vote170 views2 answers
How to start postgresql laravel
SQL
2 votes164 views1 answer
Oracle list grants on procedure
SQL
0 vote164 views1 answer
Remove binlog mysql
SQL
0 vote169 views2 answers
Sql query for getting details by id
SQL
0 vote167 views1 answer
Sql developer format sql
SQL
1 vote177 views3 answers
Union in sql
SQL
4 votes175 views2 answers
Bulk kill mysql processlist
SQL
0 vote210 views1 answer
Drop table BigQuery table columns
SQL