/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

-1 vote354 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
9 votes368 views4 answers
SQL Date Format
SQL
0 vote371 views1 answer
Adding generated time in row mysql workbench
SQL
0 vote398 views1 answer
Run sql script file and changes db name in this file using c#
SQL
16 votes385 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
14 votes370 views1 answer
Sql value of string
SQL
1 vote343 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
0 vote368 views1 answer
Oracle sql log to console
SQL
3 votes379 views1 answer
APEX elapsed time
SQL
0 vote386 views1 answer
Sql missing values
SQL