I am currently trying to create a new feature class in my Oracle SDE geodatabase and I get this error: "Underlying DBMS error[Ora 00001: unique constraint (SDE.R5_SDE_ROWID_UK) violated] [SDE.GDB_Item Relationships]".
I have tried to align the sequences following these steps:
1) check from table TABLE_REGISTRY the REGISTRATION_ID of SDE.GDB_Item Relationships table by issuing the query "SELECT REGISTRATION_ID FROM TABLE_REGISTRY WHERE TABLE_NAME = 'GDB_ITEMRELATIONSHIPS'". the query returned 5.
2) I moved forward the sequence SDE.R5 till value > the maximum value of the objectid of GDB_ITEMRELATIONSHIPS.
3) In ArcCatalog i tried to create again a feature class without succeding. it returned the same error.
Thanks in advance,