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