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

ORA-08270: sksachk: Illegal archival control string

1 Answers  


NPL-00418: received malformed ASN.1 object identifier

1 Answers  


RMAN-20298: DBMS_RCVCAT package not compatible with the recovery catalog

1 Answers  


LPX-00401: invalid QName in the XSL file

1 Answers  


ORA-39090: Cannot add devices to file oriented job.

1 Answers  






ORA-30691: failed to allocate system resources while registering a TCP/IP connection for data traffic detection

1 Answers  


DRG-12407: invalid CTX REPEAT tag attribute (string)

1 Answers  


DGM-16991: More than one resources have name "string".

1 Answers  


ORA-16169: LGWR network server invalid parameters

1 Answers  


RMAN-06599: tablespace string is not read-only

1 Answers  


RMAN-20501: redo logs from parent database incarnation cannot be applied

1 Answers  


ORA-31653: unable to determine job operation for privilege check

1 Answers  


Categories