Expand To Show Full Article
Oracle Error ORA-01176: data dictionary has more than the string files allowed by the controlfie - Developer Publish

Oracle Error ORA-01176: data dictionary has more than the string files allowed by the controlfie

Oracle 26 Views 0 Min Read

Oracle Error Message

ORA-01176: data dictionary has more than the string files allowed by the controlfie

Reason for the Error

After a CREATE CONTROLFILE, the data dictionary was found to have more datafiles than that supported by the control file.

Solution

Recreate the control file with a larger MAXDATAFILES.

Tags: