Search This Blog

2008-11-13

Special behavior of Oracle exp utility

Oracle exp and imp utilities will not create primary key index, if they have following property:
  1. constraint name is dynamic
  2. index for that primary key is manually created with different name
During import, only the index will be created, but the constraint will not.

In order to resolve such behavior, sync both constraint and index name using following approach:
  1. Rename constraint name: alter table abc.membership rename constraint SYS_C0011039 to membership_PK;
  2. Rename index name if different: ALTER INDEX abc.pk_membership RENAME TO membership_pk;

No comments:

Blog Archive