Striving for Optimal Performance
  • Home
  • Blog
    • Archive
    • Categories
  • Troubleshooting Oracle Performance
    • Description
    • Structure
    • Table of Contents
    • Forewords
    • Reviews
    • Downloadable Files
    • Addenda and Errata
  • Publications
  • Public Appearances
    • Past Public Appearances
  • Contact
  • Search
  • About

ORA-00001: unique constraint (METALINK.SYS_C005417) violated

Jul25
2009
3 Comments Written by Christian Antognini

ORA-00001: unique constraint (METALINK.SYS_C005417) violated

This is a partial screenshot of an application without a decent error handling.

Do you recognize it?

It goes without saying that no further comments are needed…

Posted in Uncategorized
SHARE THIS Twitter Facebook Delicious StumbleUpon E-mail
← Impact of Direct Reads on Delayed Block Cleanouts
A-Rows and DML Statements →

3 Comments

  1. Gary
    July 26, 2009 at 02:55 | Permalink

    Forget the application, they should be giving their unique constraints some sort of reasonable name.

    Reply
  2. Christian Antognini
    July 26, 2009 at 09:25 | Permalink

    Hi Gary

    I fully agree with you about the name of unique constraints. But, IMHO, the name of the constraints is much less important than the error handling…

    Cheers,
    Chris

    Reply
  3. Mette
    July 30, 2009 at 11:21 | Permalink

    Grin … maybe they are having trouble FINDING the code produing the error – if the developers are not allowed access
    to prodcution environment definitions, it can be rather tedious to find a constraint with quite another
    name in test & dev environments. I HATE unnamed constraints …..

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

*

*


1 × = nine

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

EvoLve theme by Theme4Press  •  Powered by WordPress Striving for Optimal Performance