• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

what is cause of ORA-25128: No insert/update/delete in Oracle?

 
jagrutkumar dalwadi
Ranch Hand
Posts: 83
Hibernate Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have got following error in production environment:

SQL state [99999]; error code [25128]; ORA-25128: No insert/update/delete on table with constraint (SYS_C0031978) disabled and validated
; nested exception is java.sql.SQLException: ORA-25128: No insert/update/delete on table with constraint (SYS_C0031978) disabled and validated.

SYS_C0031978: is constraint which sees particular field is not null. this constraint is disable currently.

Try to give some view on this.
 
Sam Falzon
Greenhorn
Posts: 5
Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tom Kyte explains this...

Question regarding "constraint state"
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic