Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: pros and cons
One annoying consequence of the "feature":
If you have a primary key with its own index and you have another plain index where a subset of its columns are the same columns as the primary key index, possibly with the columns in a different order (That's right! The column order doesn't matter.), then: If you run an import what can happen is that imp will assign the primary key constraint to the plain index and make the original primary key index a unique index with no assigned constraint name. Import can lose the original primary key constraint and index association.
![]() |
![]() |