For an upcoming project, I am required to pull data from a table on database A and load it into a table on database B.
I used FASTLOAD in my scipt for this purpose. It works fine, but in case there is any error and the script fails, the target table gets locked and we have to drop and create the table to use it again.
Therefore, I was wondering if Multiload can be used for this purpose.
Please let me know your views and suggestions for this.
Multiload behaviour is the same. To release lock in Multiload you can use command RELEASE MLOAD (I can't remember exactly command syntaxis now). Or you can run empty multyoad/fastload task - without INSERT statement - to release lock on the table.