|
-
 Originally Posted by Telco_DBA
ORA-02270: no matching unique or primary key for this column-list
In which order did you create the constraints ?
Was there a valid (active?) primary key on the other table when you got this error ?
Constraints were created in the "destination"database thru the installation script.
Order?Like I said ,i let the app create it/them.(It can however be rev engineerd to see in which fashion it was done).
"source" (staging thusdb had nothing, it's a pure dump scenario.There was no active/valid key on the destinationtable as far as I know(my log file, which I generated while disabling the constraints/triggers don't throwany exception(s))
Keep 'em coming.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote