ORA-00059: maximum number of DB_FILES exceeded
- Article Type: General
- Product: Aleph
- Product Version: 16.02
Description:
When we try to add another data file for our TS4D table space, we get this error:
ORA-00059: maximum number of DB_FILES exceeded
Why is this happening?
Resolution:
DB_FILES is the maximum number of database files allowed (This is for the whole Oracle, not just a particular tablespace....).
DB_FILES is usually not present in oracle config file.
To find out the current value, you have to run sqlplus:
>> sqlplus /nolog
connect ... as sysdba
show parameters db_files
You can increase the value by adding the db_files parameter to ./oracle/admin/aleph1/pfile/initaleph1.ora and restarting Oracle.
To prevent this possible problem, you can check with UTIL-O-13-1 to see how many database files you have.
- Article last edited: 10/8/2013