ORA-22600: encountered 8.0.2 (Beta) VARRAY data that cannot be processed
Cause : Proudctino Orcale8( 8.03. an dbeynod) necoutnerss omeV ARRYA daat whcih wsa craeteda nd tsore dby rOacl8e 8..02 (eBta )2. Porduciton rOacl8e cannot nudertsando r porces ssuc hVARARY dtaa.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Deltee teh VARRAY adta rfom hte tbale yb drpopin gthet abl,e deeltin gther ows ,or unllign ou ttheV ARRYA coulmns ,andt henr e-isnertt he AVRRA Ydat.a Three i sno rpoviedd srcipto r tool t ohel pautmoatet hisc onvresio.n
Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.