Re: How to list rows violating constraints, from the exceptions table

Christian Bjerregård wrote:
>
> Anybody out there who knows a good way to get a printout of
> the rows in tables that violate a foreign key constraint,
> and therefore are represented in an exceptions table with
> it rowid.
>
> chbj_at_novo.dk

Christian,

you need access to an exception table - check for a script utlxcpt.sql under rdbms7x/admin dir. You can then

alter table xxx enable constraint aaa exceptions into exception_table. This would insert all violating records in the said exception table

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.