-
제목
When tried to restart aborted standard reorg, received: "Aborted FC-20642" -
설명
When tried to restart aborted standard reorg, received: Aborted FC-20642AbortScript: Aborted FC-20642 FastCopy Export file /oracle/EGS/sapdata89/Quest/QUEST_SPC_TMP_94874_TAB.000000 exists (os errno 0)
Messages from stdout and stderr:
executing select count(*) -
원인
FastCopy has encountered an existing export file and will not overwrite it. The file may contain exported data from a table that was dropped during a previous reorganization that failed.
-
해결 방안
1. Delete the existing export file as follows:
Open the newly failed script in the SQL Editor and look for the export statement on which the script failed.
This shows the name of the export file.
2. Then look for the FAST_DELETE_FILE statement that contains the file's name:EXECUTE QUEST_EXEC.FAST_DELETE_FILE (FILENAME);
3. Run the statement by selecting it and pressing F8.
4. Reschedule and store the script or close it and re-run the entire script from the Scripts/Job Monitor using the Execute function.