Migration to Oracle Issue.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Migration to Oracle Issue.

  1. #1
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587

    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)
    TarryBlogging
    --- Everything was meant to be---

  2. #2
    Join Date
    Jun 2005
    Posts
    31
    Quote 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 ?

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Quote 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)
    TarryBlogging
    --- 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
  •  


Click Here to Expand Forum to Full Width