underlying dbms error ora-00001 unique constraint violated

Question

Dear All

Please help me with my new problem in ArcSDE geodatabase ,
I have layer name it landuse when i unregisterd layer the message appear
underlying dbms error ora-00001 unique constraint (GAM.A6_D910) violated  GAM.LANDUSE

I did the post and reconcile to all my data base and then compress it  , the post and reconcile succsefully and the compress succesfully but when i check unregisterd as vesion for landuse layer the messgae appear
underlying dbms error ora-00001 unique constraint (GAM.A6_D910) violated  GAM.LANDUSE

thank you

AsrujitSengupta · Answer

I would suggest creating a full backup of your geodatabase and then running the "sdegdbrepair -o diagnose_tables" to look for any orphaned records.

If any orphaned records are found, you can run "sdegdbrepair -o repair_tables" to correct those records.

As suggested in the second post of this thread, run the sdegdbrepair utilities and let us know if that helps!

RedaAli · Answer

Hi Hanan ,

Would you mind inform us,
How did you solve the first problem?

Thanks
Reda Ali

hananelyan · Answer

Dear All
The previous problem was solved.
But now when I work post and reconcile , and then I work compress , compress  has been successfully but virtually no compress because when I inquired at the Oracle gives no records, no compress that has been done successfully, knowing that I killed all users .
thenk you