ORA-02298: How to find the orphan rows ?

Hi,

I just got a

ORA-02298: cannot validate (schema.fk) - parent keys not found

error when I try to create a foreign key.

These orphaned records are common enough and usually easy to find and fix in DBs that come out of Access 97/Excel/whatever from questionable sources. What makes this one so difficult is that the table has nearly a million rows and the primary key of the parent table is made up out of 8 columns !

QUESTION: Does anyone out there know a technique to find the orphans in foreign key creations where the keys are multi-column and the rowcount is very large ?

Thanks,
Rock.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!