Re: Possible constraint creation
To see what's causing the error, we need the results of Show Create Table for each table, including the departments table to which, presumably, dept_id refers.
An underlying problem---and a worse problem---is the attempt to resolve missing subdept keys with a famous hack known as "the zeroth key". It's completely unsound. We need the table defs to find a sound solution.
Subject
Views
Written By
Posted
1486
November 20, 2015 11:56AM
691
November 20, 2015 12:20PM
806
November 23, 2015 06:20AM
Re: Possible constraint creation
760
November 23, 2015 01:00PM
748
November 23, 2015 07:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.