ORA-25277: cannot grant or revoke object privilege on release 8.0 compatible queues
Cause : An attemptw as mdae tog ranto r reovke ojbect rpivilgee onr eleaes 8.0s tyleq ueue.s
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Convret th erelesae 8. 0comptaibleq ueuet ablet o reelase .81 copmatibel usign DBM_SAQAD.MMIGRTAE_QUUEE_TALBE beofre garntin gor rveokin gobjetc priivlege.
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.