dsi_stage_all_ops

Use the dsi_stage_all_ops parameter of the alter connection command to prevent operation compilation for specified tables.

If table history must be preserved, as in the case of slowly changing dimension (SCD) tables, set dsi_stage_all_ops to on. For example:

alter connection to SYDNEY_IQ_RS.iq_db
for replicate table named lineitem_5
set dsi_stage_all_ops to "on"
Parent topic: Parameters