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-13859: Action cannot be specified without the module specification

1 Answers  


NNL-00850: Rename requests received: number

1 Answers  


ORA-29294: A data error occurred during compression or uncompression.

1 Answers  


ORA-39001: invalid argument value

1 Answers  


RMAN-08524: input controlfilecopy name=string

1 Answers  






TNS-00041: INTCTL: Navigator already running. Start operation cancelled

1 Answers  


ORA-02821: Unable to read the requested number of blocks.

1 Answers  


NNO-00609: warning: forwarder number address length number exceeds maximum of number, ignored

1 Answers  


RMAN-08157: script string written to file string

1 Answers  


QSM-01096: Materialized view with grouping sets contains duplicates

1 Answers  


LFI-01510: fread() failed(OSD return value = string) in string.

1 Answers  


ORA-09766: osnmop: buffer allocation failure.

1 Answers  


Categories