Showing posts with label Size needed for shared region is greater than segment size. Show all posts
Showing posts with label Size needed for shared region is greater than segment size. Show all posts

Monday, August 09, 2010

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

Featured Post

Ora-00921 Unexpected end of SQL Command

 ORA-00921 unexpected end of SQL command     Oracle Database Error Code Messages ORA-00921 About Help Description; Unexpected end of SQL com...

Search This Blog