Can we know the Constraint Name which was Violated

srinagesh · Post by **srinagesh** » Fri Jul 29, 2005 1:21 pm

Hi All,

Is there a way to get the Name of the Oracle Constraint which was violated during the load process?

Is there a way to get the oracle error message and not just the DBMS Code. (for example I get ora-0001, but i dont get the message Unique constraint violated)

Nagesh

chulett · Post by **chulett** » Fri Jul 29, 2005 3:57 pm

Unfortunately, no - not from the reject link inside the job. The only place the full message exists is in the job's log. So you'd need to farm that information from there after the job completes.

If you don't want to roll your own, you might want to check out Mr Duke's ETLStats package you can download from his homepage. At the very least, he's already done most of the work for you... best case, all of it!

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Jul 29, 2005 4:31 pm

Ora 1 is primary key violation.

You can link the message constraint with the table to obtain more information.

chulett · Post by **chulett** » Fri Jul 29, 2005 4:39 pm

But not and get the name of the constraint being violated.

srinagesh · Post by **srinagesh** » Sun Jul 31, 2005 7:50 am

Thanx Chulett and Sainath.