Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert Novalidate

830609Jan 25 2011 — edited Jan 25 2011
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2011
Added on Jan 25 2011
2 comments
470 views