| 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?
|
|
|
| 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: 29419
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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
|
|
|
| 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.
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
