/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 vote292 views2 answers
Sql query in dax power bi
SQL
4 votes306 views4 answers
What is primary key
SQL
0 vote307 views1 answer
How to list function in psql
SQL
0 vote285 views1 answer
Database timezone
SQL
0 vote321 views1 answer
T-sql update table variale
SQL
13 votes278 views4 answers
Mysql get last row
SQL
2 votes304 views1 answer
Sql finding longest and shortest names in a fleld
SQL
7 votes314 views3 answers
Postgresql dump and restore db
SQL
0 vote309 views1 answer
Count number of entires by months sql
SQL
0 vote321 views1 answer
How to run mysql on terminal mac
SQL