The question sometimes arises as to whether the feature SHAREPLEX_IGNORE_TRANS will work with SQL*Loader to enable Shareplex to ignore transactions invoked by SQL*Loader.
General information.
The SHAREPLEX_IGNORE_TRANS procedure needs to be invoked and then the transaction need to be executed, for Capture process of Shareplex to ignore the transaction. The direct load invoked by SQL*Loader will not be ignored by Capture since it is not a part of the transaction executed at the database level (under SQL*Plus) that ends with a COMMIT or ROLLBACK.
