How To: Check an Oracle geodatabase for duplicate GlobalID values
This article describes how check to see if there are duplicate GlobalID values in an Oracle geodatabase. This may have occurred as a result of the problem described in the Knowledge Base article Geodatabase replication synchronization can create duplicate GlobalID values in Oracle.
- Log into the Oracle geodatabase as the SDE user or owner of the geodatabase instance in SQL*Plus.
- Download and run the 'check_for_duplicate_globalids' script available here: Check_for_duplicate_globalids
This script creates a file called c:\temp\dup_glbid_report.txt. Make sure that a c:\temp directory exists, or change directory path in the script.
- Once the script complete, check the results in the dup_glbid_report.txt report.
This script goes through the datasets in each of the versions in the geodatabase. If duplicates are encountered, results similar to following are returned in the report:
Table SDE.BUILDINGS contains 1 duplicate globalid values.
The report also includes the total duplicates found at the bottom (for example):
TOTAL DUPLCATES FOUND: 2
If total duplicates found is 0, then no duplicates were encountered.