/SQL/Alter tablespace add datafile autoextend

Alter tablespace add datafile autoextend

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

1 vote370 views1 answer
Jooq convert using gbk
SQL
0 vote377 views1 answer
Mysql get date diff in months
SQL
0 vote356 views1 answer
Test connection to sql server
SQL
58 votes668 views6 answers
Create new user in postgres
SQL
52 votes619 views6 answers
Rename column sql
SQL
1 vote332 views1 answer
Stored procedure return value
SQL
0 vote462 views1 answer
Compare strings lexicographically in sql
SQL
1 vote366 views1 answer
Postgresql round double precision
SQL
6 votes333 views1 answer
Oracle trigger after connect
SQL
22 votes400 views3 answers
How to join three tables in sql using joins
SQL