The Artima Developer Community
Articles | News | Weblogs | Books | Forums
Artima Forums | Articles | Weblogs | Java Answers | News
Sponsored Link •

Java Buzz Forum
Finding table for Oracle constraint violation

0 replies.

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 flat view of this topic  Flat View
Previous Topic   Next Topic
Threaded 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

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