/SQL/Oracle alter tablespace add datafile autoextend max size

Oracle alter tablespace add datafile autoextend max size

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 vote204 views2 answers
Sql join on comma separated field
SQL
14 votes207 views4 answers
Online sql compiler
SQL
1 vote206 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote204 views1 answer
Increase speed of like queries postgres
SQL
1 vote224 views1 answer
Increase date by one day in sql oracle
SQL
1 vote188 views1 answer
Find logged in users mysql
SQL
0 vote201 views1 answer
Get last date join sql
SQL
0 vote193 views1 answer
Trigger value from maltiple table to single table mysql
SQL
25 votes223 views1 answer
How to update an attribute in MySQL
SQL
0 vote214 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL