OraFAQ Forum: General » ORA-22813: operand value exceeds system limits

Home » Other » General » ORA-22813: operand value exceeds system limits (ORACLE 10.2.0.4.0, Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-22813: operand value exceeds system limits [message #423264]

Wed, 23 September 2009 03:16

Saikirupa
Messages: 10
Registered: August 2009

Junior Member

Hi All,

When we try to create a rule from our GUI, we are getting the below error.
ORA-22813: operand value exceeds system limits

Rule Creation - It will insert values into BLOB,XMLType and Varchar2 columns.
Can any one give solution for this?

Report message to a moderator

Re: ORA-22813: operand value exceeds system limits [message #423274 is a reply to message #423264]

Wed, 23 September 2009 03:30

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-22813: 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.

Regards
Michel

Report message to a moderator

Re: ORA-22813: operand value exceeds system limits [message #423293 is a reply to message #423274]

Wed, 23 September 2009 04:17

Saikirupa
Messages: 10
Registered: August 2009

Junior Member

Hi Michel,

Ya this i got it from ora-error.com. Even for small inserts we are getting this error.
I tried to create the same rule in another schema which is in the same instance. There it was working fine.

Example :

INSTANCE1/Schema 1 : Table 1 has 6000 rows which has blob,XML type columns

INSTANCE1/Schema2 : Table 1 has 5 rows which has blob,XML type columns

We are getting the error for schema1 and not in schema2.

Report message to a moderator

Re: ORA-22813: operand value exceeds system limits [message #423298 is a reply to message #423293]

Wed, 23 September 2009 04:34

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have the code, we have not.
You have the data, we have not.
You can find the error, we cannot.

Regards
Michel

Report message to a moderator

Previous Topic:	upgrade oracle 10g release 1 to release 2
Next Topic:	bcp or copy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 03:01:09 CST 2024