Error Message
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.
