Migration from SQL server2000 to Oracle 8i Enterprise Edition----Urgent

[sumit malik]

Hi
Please tell me how to migrate SQlserver 2000 database to Oracle 8i.
If through Sql loader than how to do it plz. tell me the code.
Is there any tool for such type of
migration also.
Thanks
Sumit

[Beksy Kurian]

Sumit,
OMWB is a tool used for this purpose.
Read more...
http://otn.oracle.com/tech/migration/workbench/content.html
Regards
Beksy

[Mark Spritzler]

Hey Beksy, I downloaded the Migration tool and ran the Universal Installer, I then selected the Tool, and it failed to run.
Does it need to be on a Win 2000 at least, or will Win 98 SE work? I have Win 98 SE, and that is where it failed.
Well I think I will just use SQL Loader with ASCII files instead.
Thanks for the link
Mark

[Beksy Kurian]

Mark,
As far as I know, it should work with Win 98.
see this support matrix
http://technet.oracle.com/support/tech/migration/workbench/htdocs/supp_matrix.htm
Regards
Beksy