-
Migration to Oracle Issue.
I have a small issue:A small step in my migration from windows to linux environment.
I have this application I want to move from sql server 2000 to oracle 9iR2.
What I was able to do:
--moved data to a staging area(another oracle instance)
--created an oracle instance
--created the data(actually the application installs the schema, so no trouble here for me.
--I disable all constraints
--I disable all triggers
--Insert all data one - on -one into the destination table
--enable constraint novalidate all tables, enabling goes ok but still it throws error in my logg ora-02270.
Well I'm still in a test scenario and was wondering if anyone out here experience this typical scenarion as well.
Thanks in Advance
Tarry
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
Originally Posted by Tarry
--enable constraint novalidate all tables, enabling goes ok but still it throws error in my logg ora-02270.
Well I'm still in a test scenario and was wondering if anyone out here experience this typical scenarion as well.
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 ?
-
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
|