Old database A and database B, to achieve A data synchronization to B, the building up of materialized views in B library, put the data in the select A come over, and then set up the trigger on B library of materialized views, at the time of materialized views have data into the data in the table is inserted into the library B, the question now is whether the library B the data in the table there is A missing field last, that field is varchar2 (13 bytes), and not all no group is missing, missing tuples appears order without law, seek help from A great god!

To watch found that the problem without some float type set of fields is not normal, originally is null, are now 0
Materialized views to create the create materialized view vm_tableNew refresh fast next SYSDATE + 5/(24 * 60 * 60) as select * from tableOld @ linktoold;
Create a trigger on materialized views the create or replace the trigger tri_vm_tableNew after insert on vm_tableNew for each row
The begin insert into tableNew values (: new field name); end;

Help solution!!!!!

CodePudding user response:

no one answer?

CodePudding user response:

CodePudding user response:

LZ you put B library table where the field is defined as varchar2 (20) and look at!

CodePudding user response:

reference lon3991 reply: 3/f

LZ you put B library table where the field is defined as varchar2 (20) and look at!

To 24, also useless, still is not normal

CodePudding user response:

SADE (vmin, vmax, itermax, Np, fit and arguin) the last parameter is what mean