underlying dbms error ora-00001 unique constraint violated

3393
4
07-30-2013 11:10 PM
hananelyan
New Contributor
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
0 Kudos
4 Replies
AsrujitSengupta
Regular Contributor III
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,
0 Kudos
hananelyan
New Contributor
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
0 Kudos
RedaAli
New Contributor III
Hi Hanan ,

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

Thanks
Reda Ali
0 Kudos
AsrujitSengupta
Regular Contributor III
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!
0 Kudos