Solved

Error when trying to export database  - characterset not recognized

Posted on 2009-07-05
6
1,772 Views
Last Modified: 2013-12-19
Hello,
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.

Thanks
0
Comment
Question by:Abu Hamdan
6 Comments
 
LVL 1

Accepted Solution

by:
elkhawajah earned 50 total points
Comment Utility
The NLS_LANG of the other database that you are exporting to should have the same character set as the exporting from database..
0
 
LVL 6

Assisted Solution

by:Greg Clough
Greg Clough earned 100 total points
Comment Utility
Could you please re-post the character sets that you changed from/to, as those in the question are identical.

Could you also post the current NLS_LANG setting of the machine where you are doing the export.

Here are a couple of hints that may be helpful:

1. Generally the NLS_LANG setting will match whatever client you are using, BUT when doing an export for backup/recovery purposes then the NLS_LANG should match the character set of the database. This way no translations occur, and that means you don't have to worry about any special characters being lost.

2. An export is not usually a good backup technique, and RMAN is the suggested method. If you must use export and are running on v10g or later, then use "Data Pump" instead. It basically does the same job, but is the supported tool of choice. Export is degraded, and will eventually disappear.
0
 
LVL 47

Assisted Solution

by:schwertner
schwertner earned 50 total points
Comment Utility
For me your character sets are identical.
What and how have you changed.
The character set of a DB could be changed only if you create
a new DB with the desired Character set and Export/Import
the DB.
Other ways are cutting the corners and bring effects
like you are facing.
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 6

Assisted Solution

by:Greg Clough
Greg Clough earned 100 total points
Comment Utility
@hammdan_1980

Have you had a chance to find the info needed for us to help you?

@schwertner

Actually, you can change character sets other than export/import and it is fully supported by Oracle, but only if the target character set is a true superset of the current database, and you don't change from single to multi-byte or vice versa:

http://download.oracle.com/docs/cd/B10501_01/server.920/a96529/ch10.htm#1009580

It's not cutting a corner if done correctly, but can cause lots of trouble if you are not very careful.
0
 
LVL 7

Author Comment

by:Abu Hamdan
Comment Utility
first sorry i have been very busy during last days, and traveling to my country after assignment done. Regarding the problem i found that because i changed the characterset by updating the props$ table directly this problem occured so i found the supported corrected one which is as:

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;

ALTER SYSTEM ENABLE RESTRICTED SESSION;

ALTER DATABASE CHARACTER SET AR8MSWIN1256;


so i just run it again and everything now is working without problems

I will split the points for all since all answers helped
0
 
LVL 6

Expert Comment

by:Greg Clough
Comment Utility
I'm glad it's now working, but remember that in most cases using ALTER DATABASE to switch character sets isn't the right way to go. More common is to use export/import.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Creating and Managing Databases with phpMyAdmin in cPanel.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now