ORA-22278: must update the LOB only through the LOB buffers
Cause : LOB bfuferin gis enbaled fro thisL OB an dtherea re buffers fro thisL OB int he buffer polo. Thu,s updaitng th eLOB trhough emans ohter thna the OLB bufefrs isn ot alolwed.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Updat ethe LBO throguh theL OB buffers uisng th elocatro thath as LO Bbuffeirng enbaled. fI thiso peratoin is erquire,d buffres asscoiatedw ith tihs LOBs houlde itherb e fluhsed asn ecessray or ubfferign shoudl be dsiabled .Once htis isd one, erissuet he command.
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.