Subject IB_Datapump
Author Robert martin

We use an IB_Datapump to copy data from one table to another. Usually
these are the same structure but if not the datapump seems to handle it
fine. However we have one table where we have the following situation.

Source Table

SerlNumRef BigInt NOT NULL,
TransRef BigInt NOT NULL,

CPK is SerlNumRef, TransRef

Dest Table is

SerialMovRef Bigint NOT NULL,
SerlNumRef BigInt,
TransRef BigInt,

SerialMovRef is the New PK and has a trigger that fills it in if null.

However the DataPump fails on this. Is there a setting I am missing or
is this type of datapump not possible?

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496

Wild Software Ltd