Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to address ORA-22813 ?

How to address ORA-22813 ?

From: jayaraj rengarajan <jayaraj.rengarajan_at_gmail.com>
Date: Tue, 9 May 2006 15:47:18 -0400
Message-ID: <570313960605091247h7bb2f817y32bb748bd7b2272a@mail.gmail.com>


One of our application user is saying, he got this error when trying to get the ouput using collections !?
**
*oerr ora 22813

22813, 00000, "operand value exceeds system limits"

// *Cause:  Object or Collection value was too large. The size of the value
//          might have exceeded 30k in a SORT context, or the size might be
//          too big for available memory.
// *Action:  Choose another value and retry the operation.

***

pga_aggregate_target value is set to 250MB and the DB version is 9.2.0.2

Regards,

Jay

**

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 09 2006 - 14:47:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US