Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-22280: no more buffers available for operation



ORA-22280: no more buffers available for operation..

Answer / guest

Cause: There are two causes: (1) All buffers in the buffer
pool have been used up by previous operations (2) Attempt to
flush a LOB without any previous buffered update operations.

Action: For (1), flush the LOB(s) through the locator that
is being used to update the LOB. For (2), write to the LOB
through a locator enabled for buffering before attempting to
flush buffers.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01581: attempt to use rollback segment (string) new extent (string) which is being allocated

1 Answers  


ORA-02199: missing DATAFILE/TEMPFILE clause

1 Answers  


TNS-12678: Authentication disabled but required

1 Answers  


ORA-27148: spawn wait error

1 Answers  


ORA-16178: Cannot specify remote destinations in archivelog manual mode

1 Answers  






ORA-13148: failed to generate SQL filter

1 Answers  


RMAN-11006: WARNING: test recovery results: string

1 Answers  


ORA-00054: resource busy and acquire with NOWAIT specified

1 Answers  


PLS-00906: Compilation is not possible

1 Answers  


DRG-50913: first document requested string is not a positive number

1 Answers  


ORA-27092: size of file exceeds file size limit of the process

1 Answers  


ORA-39147: cannot migrate Data Pump queue table ownership to this instance

1 Answers  






Categories