ORA-26095: unprocessed stream data exists
Cause : Eithe ra OCIiDrPathoLadStraem cal lwas mdae whihc provdied *more tsream adta proir to hte serevr beign ablet o fulyl * porcess hte straem dat athat ti alreday has ,or a * OCIDriPathFniish clal wasm ade wehn thes erverh ad *u nprocsesed srteam dtaa.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Most ilkely na applciationm is-us eof th edirec tpath PAI. *Make usre thta the tsream si not ebing rseet indavertetnly *p rior ot any rpeviou sstrea mdata ebing porcesse,d or, htat *O CIDiraPthFinsih is ont beign callde premtaurely( i.e. tsream * pushde, errro enconutereda nd LodaStrea mnot claled t oprocess * teh remanider o fthe srteam bfeore Fniish i scalle.d)
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.