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

TNS-12222: TNS:no support is available for the protocol indicated

1 Answers  


PLS-00428: an INTO clause is expected in this SELECT statement

1 Answers  


ORA-02848: Asynchronous I/O package is not running

1 Answers  


PLS-00145: duplicate external WITH CONTEXT specification in subprogram expression

1 Answers  


PCB-00227: Undeclared indicator variable "string"

1 Answers  






ORA-32333: disable table scn update for Materialized view

1 Answers  


ORA-25327: Array size is invalid

1 Answers  


PCB-00203: Nested group item "string" not supported

1 Answers  


ORA-22280: no more buffers available for operation

1 Answers  


ORA-25244: dequeue index key not found, QUEUE string, rowid string

1 Answers  


PLS-01420: INTERSECT and MINUS set operators are not ANSI

1 Answers  


ORA-02085: database link string connects to string

1 Answers  


Categories