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. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------