Sunday, April 21, 2013

ORA-00219 Required Control File Size Exceeds Maximum Allowable Size

Error Code
ORA-00219

Description
Required control file size (string logical blocks) exceeds maximum allowable size (string logical blocks).

Cause
Possible cause of this error is, an invocation of CREATE DATABASE or CREATE CONTROLFILE was executed specifying a combination of parameters that would require the control file size in blocks to exceed the maximum allowable value.

Action
To fix this issue, in the case of CREATE DATABASE or CREATE CONTROLFILE, use a different combination of MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, and MAXINSTANCES clauses.

reference

No comments:

Post a Comment