This email is subject to Terms and Conditions as found in our Email Legal Notice which forms part of this email message in terms of section 11 of the Electronic Communications and Transaction Act 25 of 2002. Please click on http://www.mf.co.za/content/EMAIL_Legal_Notice.asp , or send a blank email to [Email address protected] By receiving, reading or acting upon this email you will automatically be bound by the terms of the Email Legal Notice.
Mutual & Federal Insurance Company Limited
Authorised Financial Services Provider
-----
Looks like you may have to look for any patches available for 9.2.0.2.
This is a memory leak issue which was fixed.
http://apps.cocreate.com/downloads/EU-OSM/oracle/9.2.0.4/PC/Oracle_9204_patch_win_Readme.html
>>> "Shalini "
<oracledba-ezmlmshield-x67522330.[Email address protected] 29/06/2007
09:20 >>>
Hi Dba's
I am running an sql and gets an error ORA-22813 . I have 2 versions of
oracle 9.2.0.1 and 9.2.0.2 . The sql runs fine on 9.2.0.1 but not in
9.2.0.2. I have got enough memory available . The query returns 150,000
records . Both servers have the same amount of memory available.
Any help
Thanks
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The information in this message and any attachments is
privileged,confidential and/or exempt from disclosure under applicable
law.
If you are not the intended recipient, please do not copy, use or
disclose the information to others;also please notify the sender by
replying to this message, and then delete it from your system.E-mail
transmission cannot be guaranteed to be secure, error and virus
free. The sender therefore accepts no liability for any errors or
omissions in the contents of this message, which arise as a result of
e-mail transmission
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page