The Artima Developer Community
Sponsored Link

Java Buzz Forum
Finding table for Oracle constraint violation

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
Christopher Wong

Posts: 128
Nickname: cwong15
Registered: Sep, 2009

Christopher Wong is a senior software engineer at lifeIMAGE.
Finding table for Oracle constraint violation Posted: May 27, 2012 8:40 PM
Reply to this message Reply

This post originated from an RSS feed registered with Java Buzz by Christopher Wong.
Original Post: Finding table for Oracle constraint violation
Feed Title: Chris Wong's Development Blog
Feed URL: http://chriswongdevblog.blogspot.com/feeds/posts/default
Feed Description: This is a development-focused blog covering BlackBerry and Java software development.
Latest Java Buzz Posts
Latest Java Buzz Posts by Christopher Wong
Latest Posts From Chris Wong's Development Blog

Advertisement
When Oracle reports a constraint violation, you might get something unhelpfully cryptic like: ORA-00001: unique constraint (FOO.SYS_C003567231) violated The constraint is system-generated, based on UNIQUE being specified in the DDL, so the name is unhelpful. With no other information, finding the affected table can be difficult. You can query for the table with the following SQL: select

Read: Finding table for Oracle constraint violation

Topic: Generic Text Comparison Tool with LCS Approach Previous Topic   Next Topic Topic: Log JDBC operations with Log4jdbc

Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use