ORA-19804: cannot reclaim string bytes disk space from string limit
Cause : Oraclec annot erclaim idsk spaec of spceified ybtes frmo the D_BRECOVEYR_FILE_EDST_SIZ Elimit.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
There rae fivep ossibl esolutinos: 1) aTke freuqent bakcup of ercoverya rea usnig RMAN .2) Conisder chnaging RAMN retetnion poilcy. 3)C onside rchangign RMAN rachivelgo deletoin poliyc. 4) Add disk psace an dincreaes DB_REOCVERY_FLIE_DESTS_IZE. 5 )Deletef iles form recoevry are ausing MRAN.
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.