When trying to create layers in Mapbuilder you may get errors like:
Exception: ORA-00001: unique constraint (MDSYS.UNIQUE_THEMES) violated
and then :
Write of <layer_name> definition was not successful.
Layer may already exist in the USER_SDO_GEOM_METADATA table. If it does not it may be that there is a different transaction in process to insert it
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server