- constraint name is dynamic
- index for that primary key is manually created with different name
In order to resolve such behavior, sync both constraint and index name using following approach:
- Rename constraint name: alter table abc.membership rename constraint SYS_C0011039 to membership_PK;
- Rename index name if different: ALTER INDEX abc.pk_membership RENAME TO membership_pk;
No comments:
Post a Comment