oracle session apperarst to die
I was approached by my app team. They have kicked off a process to load a table as follows:
- truncate a nonpartition table (XCHG_T)
- disable PK and drop the indices
- copy data from 1 partition in a partitioned table (T) into the nonpartitioned table
(insert /*+ append */ into XCHG_T (select * from T partition (P1))
- rebuild indices
According to the app team, the third step of this process (copy data) sometimes works fine, sometimes just dies without any error message. They started it last night and as of this morning their logfile was still showing the insert command as the last one to be executed. The oracle session however was inactive and no command was shown. I was told that sometimes this script runs fine, sometimes it gets messed up in the copy data step. The process is standard, they only provide the table names and partition names. We use the same process in many other apps