Live-Reorg
During reorg, users may come across with error:
I was running a Traditional Reorg script that only had one table in it. I got the following error in the log file:
03/21 07:48:10 Open write fifo ../log/QUESTLR.Mar21_2004.032104_appst_into_po.ip
c oserror=6
03/21 07:48:10 Can't find pid 7855
03/21 07:48:10 QSA-20392 Internal error in script engine at qexecd.c:1224
For example, the script started at 07:53:11 and ended at 07:53:11. The QSA daemon qexecd opened the IPC file at 07:53:13 and the script already finished, so it fails.
WORKAROUND
Add the following sql at the end of the script:
begin
dbms_lock.sleep(15);
end;
This will delay 15 seconds before it ends and will give the QSA daemon time to open the IPC file.
