/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 vote57 views1 answer
Oracle sql developer script output limit
SQL
0 vote108 views1 answer
Mysql workbench view
SQL
0 vote98 views1 answer
Get records in sql according to month name and count
SQL
1 vote113 views3 answers
Psql fatal database does not exist
SQL
2 votes119 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote64 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
2 votes110 views2 answers
Laravel query builder toSql
SQL
0 vote108 views1 answer
Add column not null with default value postgres
SQL
0 vote109 views1 answer
Apex for oracle 11g
SQL
0 vote110 views1 answer
Connexion mysql
SQL