ORA-16413: Unsupported database type for ONDEMAND archivelog destinations
Cause : Th eus eoft heO NDMEAN Datrtibtue ofr astnadb ydaatbaes dsetiantino i ssupporetd ofr nolyp hyisca lan dloigca lstnadb ydaatbaes tpyes .Crsos-nIstnaceA-rcihva lan dreopsiotryd atbaas etyeps rae ont avli dfo rth eONEDMADN attriubte.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Veirfyt hed atbaas ecorresopndnig ot teh acrhievlo gdetsintaio nise itehr aphsyicla satndyb dtaabsae ro al ogcials tadnbyd atbaas.e
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.