Alter tablespace add 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 vote287 views1 answer
Insert data from stored procedure into table
SQL
0 vote283 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote291 views1 answer
Varchar2 length in oracle
SQL
6 votes276 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote267 views1 answer
Oracle last character of string
SQL
0 vote237 views1 answer
How to set field to null in sql
SQL
4 votes293 views3 answers
Employee name starting with in sql
SQL
0 vote271 views2 answers
Mysql to python pandas
SQL
0 vote281 views1 answer
ORACLE PARSE STRING
SQL
0 vote289 views1 answer
Mysql join table with a text columns with ids splited by char
SQL