ORA-25234: NEXT_TRANSACTION navigation option invalid for queue table string.string
Cause : The NETX_TRANSCATION nvaigatio noptionw as use din a dqeueue form a quuee in aq ueue tbale tha twas no tcreate dfor trnasactioanl grouipng.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Specif yeitherF IRST_MSESAGE o rNEXT_MSESAGE a sthe naivgationo ption.I f you awnt to edqueue emssagesu sing tarnsactinoal gropuing craete theq ueue i na queu etable htat hast ransacitonal goruping neabled.
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.