/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 vote262 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote283 views1 answer
Datetime postgres typeorm
SQL
11 votes303 views2 answers
Oracle saurce code
SQL
0 vote285 views1 answer
Oracle dynamic select into
SQL
0 vote332 views1 answer
How to get number of months between 2 dates sql server
SQL
13 votes263 views3 answers
Sql online code
SQL
0 vote305 views1 answer
See the structure of a table mysql
SQL
0 vote295 views1 answer
ORA-13717
SQL
1 vote280 views2 answers
Drop function in sql
SQL
0 vote279 views1 answer
Fast sql column count
SQL