All Forums Tools
abhijitvyas 51 posts Joined 08/06
04 Aug 2006
MLOAD Restartability

HiI do have a scenario where in which I need to Restart MLOAD from the begining rather than from the Latest checkpoint. can any body tell how to do so?One more que is regarding Fastload as fastload can not load the duplciates eventhough the table is multiset. can anybody guide me regarding what is the reason behind it?RegardsAbhijit

mahyan 6 posts Joined 07/06
04 Aug 2006

Hi Abhijit,1. Drop the ET, UV, WT, ML tables, release mload on the table & restart the load.2. Fload can not load duplicate records. I know that this does not answer your question, but That's how it is designed. Instead, Mload in insert mode can be used to solve this.

Fred 1096 posts Joined 08/04
04 Aug 2006

Be careful. This works as long as MLOAD has not started the Apply phase. After that, "starting over" is problematic since MLOAD does not use Transient Journal logging (cannot be backed out). Don't drop the worktables until AFTER you do RELEASE MLOAD and get either "success" or "MLOAD not active" status returned.

You must sign in to leave a comment.