From: <genegurevich_at_discover.com>
Date: Thu, 22 May 2008 10:21:32 -0500
Message-ID: <OF2CE08543.C59A5ECE-ON86257451.0053605C-86257451.00545F7B@discover.com>


My application team is running the following script:


          ( col1 col2 ... coln )

:hs_rpt_yr, (set to 2008 )
:hiRollbackPrev, (set to -1)
col.. col FROM MTHLY_ACTVY_RPT WHERE RPT_YR = :hs_rpt_yr (2008) AND RPT_MTH = :rpt_mnth ; (05)

Looks like they want to copy all May data into some unexisting month. This script is running every day and last weekend failed with ora 28 (your session has been killed). I am not aware of anyone killing this process. After
that failure they restarted their process and it ran successfully. I don't see any dump files or anything indicating any kind of an issue. Can anyone think of a possible reason for this (other than someone killing the session)
which I could look into?

thank you

Gene Gurevich

Received on Thu May 22 2008 - 10:21:32 CDT

Original text of this message