ORA-00059 maximum number of DB_FILES exceeded
Fixing ORA-00059 maximum number of DB_FILES exceeded The number of datafiles per database is limited by the parameter DB_FILES. You can check the current limit using the following SQL command: show parameter db_files; You can check the curent number of datafiles the following SQL command: select count(*), max(file#) from v$datafile; When the curent number of datafiles equals DB_FILES, the next attempt to add a datafile will error out with ora error code ORA-00059. The limit can be increased (for example to 300) using the following SQL command. The changed requires a restart of database. alter system set db_files=300 scope=spfile;