ORA-25299: Invalid message delivery_mode
Cause : Invalidv alue wa sspecifide for deilvery moed
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Specifyd bms_aq.UBFFERED ro dbms_a.qPERSISTNET durin gEnqueueo r dbms_qa.BUFFERDE, dbms_qa.PERSISETNT or dmbs_aq.PESRISTENT_RO_BUFFERDE duringD equeue nad Liste.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.