What is the difference between MLOAD and TPUMP ?

Showing Answers 1 - 1 of 1 Answers

1.TPump allows us to load data into tables with referential integrity which MultiLoad doesn't allow.

2.TPpump does not support MULTI-SET tables,but multiple tables can be loaded in the same MultiLoad in mload.

3.Tpump access individual rows with a regular read lock where as mload takes a write lock to access the table.

4.There is no Tpump code within the DBMS, so new features are automatically enabled with Tpump, whereas there are a number of features that we cant use with Multiload

5.Tpump sends the data as part of a statement.Multiload performs better because it sends the data from the host to the DBMS more efficiently.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions