can any one comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i. I mean how is oracle 9i advantageous when compared to oracle 8 or 8i when used in informatica

it's very easy
Actually oracle 8i not allowed userdefined data types
but 9i allows
and then blob,clob allow only 9i not 8i
and more over list partinition is there in 9i only