ORA-02786: Size needed for shared region is greater than
segment size



ORA-02786: Size needed for shared region is greater than segment size..

Answer / guest

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.

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCB-00301: Use of non-ANSI function is an Oracle extension

1 Answers  


ORA-24143: invalid evaluation context name

1 Answers  


ORA-09319: slgtd: unable to obtain the current date and time

1 Answers  


ORA-23380: propagation mode "string" is not valid

1 Answers  


ORA-25157: Specified block size string is not valid

1 Answers  






ORA-27036: translation error, unable to expand file name

1 Answers  


ORA-09282: sllfrb: error reading records

1 Answers  


LCD-00208: unexpected keyword in value list [string]

1 Answers  


PLS-00654: PARTITION/ORDER/CLUSTER BY are allowed for only with PARALLEL_ENABLE

1 Answers  


RMAN-07506: Do you really want to catalog the above files (enter YES or NO)?

1 Answers  


RMAN-06120: uncataloged archive log

1 Answers  


LPX-00267: could not resolve relative URL ~s

1 Answers  


Categories