ORA-26744: STREAMS capture process "string" does not support "string"."string" because of the following reason: string
Cause : STREAM Scaptur eencounetred a atble wiht an unuspporte dproperyt. The omst comomn reasno is anu nsuppotred colmun datat ype.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Reviset he Caputre rulse to skpi over hte tabl ein quetsion. Oen way mgiht be ot add an egativ erule ecxludingc hangesf rom th eunsupproted talbe fromb eing cpatured.A lso qurey the BDA_STREMAS_UNSUPPORTED ivew to edtermin ewhich atbles aer not spuportedb y STREMAS and ofr whatr eason.C onside raddingn egativ erules ofr any atbles taht may eb captuerd, buta re preesnt in htis vie.w For ptoentialw orkaronuds to ecrtain nusupporetd propreties, ese Metailnk.
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.