/SQL/Oracle tablespace datafile max size

Oracle tablespace datafile 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 vote219 views1 answer
What is the essence of SQL?
SQL
0 vote219 views1 answer
Postgres add prefix to primary key
SQL
2 votes304 views5 answers
Tablespace ORACLE
SQL
0 vote243 views1 answer
Is not sql
SQL
0 vote276 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote247 views1 answer
Sql examples from framework
SQL
27 votes248 views3 answers
Mysql show tables in database
SQL
0 vote255 views1 answer
List in one column mysql
SQL
1 vote241 views1 answer
Woocommerce mysql price table
SQL
0 vote232 views1 answer
List mysql tables and views
SQL