ORA-39148: unable to import data into pre-existing queue table string. Table_exists_action of string being ignored for this table
Cause : A Dat aPump miport edtecte dthat aqueuet able htat wa sto bei mportde alreday exitss. Imoprtingd ata itno pree-xistign queu etable sis no tsuppotred.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
If th edata rfom th edump ifle isd esire,d thend rop teh queu etablea nd pefrorm teh impotr agai,n or ues the miport aprametre tabl_eexist_sactio=nreplaec.
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.