/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 vote110 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote128 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
2 votes108 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote106 views1 answer
Mysql bash execute sql file
SQL
5 votes106 views3 answers
Select tables from mysql database
SQL
0 vote93 views1 answer
Mysql update sequence with order by
SQL
1 vote106 views1 answer
Select not matching data from two tables
SQL
1 vote62 views1 answer
Strict in postgres SQL
SQL
0 vote93 views1 answer
Insert thai language sql server
SQL
0 vote111 views1 answer
Prodection ready postgres database step by step
SQL