/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 vote313 views2 answers
How to count codition
SQL
0 vote271 views1 answer
Psql no such file or directory
SQL
9 votes273 views2 answers
Oracle all tables in schema
SQL
18 votes286 views3 answers
Mysql number format
SQL
11 votes285 views2 answers
Having in sql
SQL
21 votes298 views6 answers
Change column in mysql
SQL
20 votes272 views5 answers
Mysql reset auto increment to 1
SQL
0 vote283 views1 answer
Test connection to sql server
SQL
16 votes334 views1 answer
Sqlserver add column to table
SQL
0 vote290 views1 answer
Fast sql column count
SQL