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.

No comments:

Post a Comment

Thanks for your comment.