No More ORA-1118 – cannot add any more data files: limit of XX exceeded

ORA-1118 occurs when the database has hit the MAXDATAFILES limit and to resolve it, you need to 1. alter database backup controlfile to trace; 2. Shu immediate; 3. Increase MAXDATAFILES in backed-up controlfile. 4. Move/Rename the existing controlfiles 5. Startup nomount 6. Execute the create controfile command 7. alter database open; The steps 5 and … Continue reading No More ORA-1118 – cannot add any more data files: limit of XX exceeded