My problem as follows:
i recently changed character set from ARABIC_BAHRAIN.AR8MSWIN1252 to ARABIC_BAHRAIN.AR8MSWIN1252,, and everything went fine according to have arabic enabled on the db. But one problem occured is that whenever i try to take backup i have this error below:
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user testuser
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 6552 encountered
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized
EXP-00000: Export terminated unsuccessfully
I tried dropping user and re-create again ,, but same problem still appears.