/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

1 vote74 views1 answer
Pagination sql
SQL
0 vote125 views1 answer
Oarcale list objects
SQL
2 votes132 views1 answer
Oracle find constraints referencing a table
SQL
6 votes128 views2 answers
How to get yesterday date in mysql
SQL
0 vote131 views5 answers
Mode sql course
SQL
0 vote153 views1 answer
Table structure in sql
SQL
10 votes129 views4 answers
Sql server pagination
SQL
0 vote109 views1 answer
Doesn't have default value mysql
SQL
0 vote107 views1 answer
Postgres set default schema
SQL
2 votes114 views1 answer
Import database in mysql command line xampp
SQL