Oracle DBA, How To, Error, Cause and Action

ORA-00242: maximum allowed filename records used up in control file

ORA-00242: maximum allowed filename records used up in control file




Cause: Failed to create a new filename record entry in the control file because the maximum allowed filename records have been allocated and are in use.




Action: Free up controlfile filename section entries by dropping unwanted tablespaces/datafiles/redofiles.