Insert Novalidate
830609Jan 25 2011 — edited Jan 25 2011Hi,
I am inserting data from one table to another but giving me error:
Error report:
ORA-00001: unique constraint (ADEMPIERE.AD_ALERT_KEY) violated
ORA-06512: at line 5
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
I want to insert data in a table but with out checking any constraint if its available on destination table like FK dependencies or Primary key dependencies , I want to just insert data with out any constraint check and after insertion is complete i will enable constraint again, presently I disable all constraint then i am doing this.
Or you can say I want a insert query with novalidate true.
If any one knows the solution plz do let me know.. i think i got stuck on it..
Regards,
Manu