Re: Problem creating foreign keys

From: Yuk Hon Johnny Chan <jychan_at_corp.hp.com>
Date: 1995/09/18
Message-ID: <43kfa3$8np_at_hpcc48.corp.hp.com>#1/1

Lois Appleton (applet_at_mailhost.sasknet.sk.ca) wrote:
: I'm trying to create a foreign key on a table. I have successfully created
: foreign keys on 11 tables using the data field client_number. When I try to
: create it on this table it fails telling me there is no matching values but I
: can do a join on the two tables using client_number.

: The data field client_number has been defined the same on all tables.

: Any ideas or suggestions?

there's an Oracle bug whereby analyzed objects cannot be setup with ref integrity. i am not entirely sure if you are encountering this, but try deleting the table statistics before creating your constraints.

Johnny Chan
Independent Oracle Specialist Received on Mon Sep 18 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Chris Hamilton: "Re: Foreign key constraints or indexes...which comes first?"
Previous message: Andy Chan: "Re: No CONNECT INTERNAL as root ?!"
In reply to: Lois Appleton: "Problem creating foreign keys"
Next in thread: Chris Hamilton: "Re: Foreign key constraints or indexes...which comes first?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message