exp/imp unable to create unix index

Hi gurus I had oracle1452 when imp/exp database from test to prod databases. I have no idea why but found out from both imp and exp log that record exp/imp is the same while unique index still exist in test database exporting tablePA_PROJECTS_ALL 3160 rows exported

AW: exp/imp unable to create unix index

18:40 An: Multiple recipients of list ORACLE-L Betreff: exp/imp unable to create unix index Hi gurus I had oracle1452 when imp/exp database from test to prod databases. I have no idea why but found out from both imp and exp log that record exp/imp is the same while unique index still exist

Re: exp/imp unable to create unix index

Were the tables (Where you imported / PROD ) EMPTY ??? What is the version of ORACLE that you are using ?? Is this constraint ENABLED in TEST (From where you exported).. ?? Check.. chances are that it is disabled there.. HTH Make a FREE long distance call