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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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