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.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.