FPSINPUT.BLD_FIND_DUPLICATES

>

> FPSINPUT.WIP_WAFER_HIST_LOOP

View FPSADMIN.BLD_FIND_DUPLICATES

This view builds queries to help resolve issues with duplicate primary/unique keys in tables. It produces two SQL queries for each primary/unique key selected: FIND_DUPLICATE_KEYS -- this query selects only the key records which are duplicated in the ref-view FIND_ROWS_W_DUPLICATE_KEYS -- selects all records from the ref-view ordered with duplicates at the beginning Note that Oracle message looks like "ORA-00001: unique constraint (FPSAPP.TABLE_NAME_PK) violated" so we include the owner_dot_constraint column so you can just copy/paste. Example usage from Oracle error message (one row): select * from bld_find_duplicates where owner_dot_constraint = 'OWNERCONSTRAINT'; Example usage by table (one row for each unique key): select * from bld_find_duplicates where table_name = 'TABLE'; If you would to build a query to remove the duplicates, see the BLD_REMOVE_DUPLICATES view.