ORA-02786–Size Needed for Shared Region is Greater than Segment Size

Oracle database error code ORA-02786 – Size needed for shared region is greater than segment size

Oracle Database Error Code ORA-2786 Description :
 
Size needed for shared region is greater than segment size


Error Cause:
 
The size of the shared segment that was specified for the shared buffer region is less than the number of bytes required. The first field of the “additional information” field is the size needed. The second is the size of the segment

How to Solve?

Use a larger size segment or let the package allocate its own