Date: Thu, 22 May 2008 10:21:32 -0500
My application team is running the following script:
INSERT INTO MTHLY_ACTVY_RPT
( col1 col2 ... coln ) SELECT
: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.
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?
Gene GurevichReceived on Thu May 22 2008 - 10:21:32 CDT