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
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
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