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.
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