HOW TO

Check an Oracle geodatabase for duplicate GlobalID values

Last Published: July 21, 2023

Summary

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.

Procedure

  1. Log into the Oracle geodatabase as the SDE user or owner of the geodatabase instance in SQL*Plus.
  2. Download and run the 'check_for_duplicate_globalids' script available here: Check_for_duplicate_globalids
Note:
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.
  1. 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.
{6CB18410-D7D5-4C29-B0EC-0F3C5C759442}, Count:77
{096C0C25-6C8A-4F16-AFCD-3A64698E5747}, Count:15

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.

Article ID:000012667

Software:
  • ArcGIS Server

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic