underlying dbms error ora-00001 unique constraint violated

[hananelyan]

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]

Hanan,

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.

Hope this helps!

Regards,

[hananelyan]

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

[RedaAli]

Hi Hanan ,

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

Thanks
Reda Ali

[AsrujitSengupta]

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!