Logical standby

From: Paul Baumgartel <treegarden_at_yahoo.com>
Date: Tue, 01 Jul 2003 10:25:50 -0700
Message-ID: <F001.005BCF75.20030701085005@fatcity.com>

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). Received on Tue Jul 01 2003 - 12:25:50 CDT