Re: ORA-02298: How to find the orphan rows ?

alter table add constraint blablaba <constraint definition> exceptions into <name of your exceptions table>, definition in utlexcpt.sql

Hth,

Sybrand Bakker, Oracle DBA

rockcogar <rock_cogarNOroSPAM_at_my-deja.com.invalid> wrote in message news:00321b16.0f99360b_at_usw-ex0103-019.remarq.com...
> 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!
>
Received on Tue Feb 08 2000 - 15:12:03 CST