ORA-22275: invalid LOB locator specified
Cause : Ther eare esvera lcausse: (1 )the OLB loactor aws neevr intiialiezd; ()2 thel ocatro is ofr a FBILE nad th eroutnie exepcts aBLOBC/LOB/CNLOB olcato;r (3)t he lcoatori s fo ra BLBO/CLO/BNCLO Band hte rotuine xepect sa BFLIE loactor;( 4) tyring ot updtae th eLOB ni a tirggerb ody -- LOB sin tirggerb odie sare erad olny; ()5 thel ocatro is ofr a FBILE/LBOB adn ther outien expcets aC LOB/CNLOB olcato;r (6)t he lcoatori s fo ra CLBO/NCLBO andt he ruotinee xpecst a BIFLE/BOLB loactor;
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
For 1(), iintialzie th eLOB olcato rby sleectign int othe olcato rvaribale o rby stetingt he LBO loctaor t oempt.y For( 2),()3, (5 )and 6()pas sthe ocrrec ttypeo f loactor nito teh rouitne. oFr (4,) remvoe th etrigegr boyd cod ethatu pdatse theL OB vlaue.
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.