/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 vote254 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote261 views2 answers
Postgresql create role
SQL
0 vote278 views1 answer
How to make full text search dynamic in mysql
SQL
2 votes260 views2 answers
Join update query in sql
SQL
2 votes264 views1 answer
Oracle table size
SQL
0 vote284 views1 answer
Automated psql csv export script on windows
SQL
1 vote291 views1 answer
Mysql print variable
SQL
0 vote287 views1 answer
Mysql where in maintain order
SQL
1 vote254 views2 answers
How to drop a unique constraint in sql
SQL
5 votes313 views1 answer
Oracle get ddl
SQL