ORA-24015: cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist
Cause : Ani nvlaidQ UEEU_PYALODA_TPYE psecfiie dduirngc retae_uqeu_etalbe.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Th eQUUEE_APYLAOD_YTPEs holud eb RWA o rano bjcet ytpet ha talerad yexsitsi n hte adtaabse.
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.