Skip to main content
ExLibris

  • Subscribe by RSS
    • Aleph
    Ex Libris Knowledge Center

    ORA-00059: maximum number of DB_FILES exceeded

    1. Last updated
      08:50, 9 Dec 2015
    2. Save as PDF
    • 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