Hi,
I have a warehouse application, and to load the data we first of all disable the constraints using dynamic SQL and EXECUTE IMMEDIATE (code is ALTER TABLE <<table_name>> DISABLE CONSTRAINT <<constraint>>). We loop through all constraints on the table.
Then we make the inserts - again using dynamic SQL (with an /* +APPEND */ hint, if that's relevant) and it's at this point that the procedure throws the ORA-00001 error.
Checking on the table I can see that the unique key is disabled, but the associated index still exists.
We are migrating this app to 10g from 8i, and it works fine on 8i. I have tried checking the user privileges are the same, but otherwise I don't understand.
TIA
David.