Thanks hunnies
This in-doubt transaction is really a pain in the neck....we haven't resolved
it long time ago.

And the ora-600 too. My only choice was to recreate the database, reinstall
everything, because it wont allow u to create another db or instance since
all the db scripts will hit the ora-600. good thing Its a first installation.

So after re-installing 10g i imported it per user per table and skip the in-doubt
table and then all is fine now