/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 vote278 views1 answer
Spring boot mysql connection properties
SQL
0 vote258 views1 answer
Sql server remove 0 from left
SQL
14 votes303 views5 answers
Set password for postgres user ubuntu
SQL
1 vote276 views2 answers
Sql insert timestamp
SQL
0 vote316 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
8 votes279 views1 answer
Oracle search code in packages
SQL
1 vote267 views2 answers
Oracle list partitioned tables
SQL
0 vote246 views1 answer
Sql examples from your work
SQL
3 votes266 views2 answers
Monthname sql
SQL
1 vote282 views1 answer
Mysql select for update ejemplo
SQL