Is it possible to let compare ignore certain Oracle errors and fix the rest of out of sync? For example, can compareignore ORA-0001 but not ORA-01403 when fixing the out of sync. One of the reason that prompts users to ask this is that they may not care about certain type of out of sync but want compare to take care of the remaining type of out of sync on a table.
One of the reason that prompts users to ask this is that they may not care about certain type of out of sync but want compare to take care of the remaining type of out of sync on a table.
It is not possible to direct compare to selectively ignore out of sync on a table (by the type of out of sync). There are various ways in which compare can selectively sync the rows that satisfy a certain condition and ignore out of sync on other rows (using where clause), as well as only synchronizing the table based on the source tables primary or unique key (using key repair option) but there is no feature within compare that will ignore certain type of out of sync.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center