I misspoke--there ARE in fact orphan records in the child table, and
they're the ones inserted by the import on the primary. So this would
seem to be a problem of the order in which operations are applied on
the standby--perhaps due to parallelism in the apply process.
Am I making any sense here? ;-)
- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> I have successfully (on the third attempt) gotten a logical standby
> database up, running, and applying changes from the primary.
> However,
> I quickly ran into a problem, and I'm wondering if anyone else has
> seen
> it.
>
> On the primary, I ran a script that disables foreign keys, imports
> data
> into existing tables, and re-enables the FKs. It runs with no errors
> on the primary, but the attempt to re-enable the first FK on the
> standby throws an error
>
> ORA-02298: cannot validate (.) - parent keys not found
>
> However, (and here's the strange part), querying the table in
> question
> shows that there are _no_ orphan records in the child table. In
> fact,
> a comparison of the tables on the two databases shows that their
> contents are identical.
>
> Now, I know that applying DDL to a standby can be problematic, but
> this
> result makes no sense at all.
>
> Any ideas, comments, or expressions of sympathy are welcome.
>
>
>
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Paul Baumgartel
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Jul 01 2003 - 13:14:08 CDT