Have you checked out the Oracle migration workbench ?

I have once (a long time ago) converted a SQL*SERVER to Oracle and it work OK.

Though I nevered tried it with LOBs and stuff like that.