Topic: Database Administration >> export character set problem - urgent
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: export character set problem - urgent |
| silambu |
Posted: Oct 04, 2007 04:23:38 AM |
Total Post: 1
Joined: Oct, 2007
|
EXP-00041: Export done in server's UTF8, different from user's character set
US7ASCII
please explain in the above error where can I identify server's UTF8 (character set)
and also where can I identify user's character set US7ASCII
It seems that my server's character set was 'UTF8'
1.select * from nls_database_parameters where parameter = 'NLS_CHARACTERSET'
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
UTF8
2. so where can I identify my user' character set
|
|
|
 Mohammed Taj |
| Posted: Oct 04, 2007 04:29:18 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
EXP-00041: Export done in server's UTF8, different from user's character set
US7ASCII
[oracle-l] || [Date Prev] [12-2004 Date Index] [Date Next] || [Thread Prev] [12-2004 Thread Index] [Thread Next]
RE: Export throws EXP-41 error.
From: "Johnson, George" <GJohnson@xxxxxxx>
To: "'arul.kumar@xxxxxx'" <arul.kumar@xxxxxx>, oracle-l@xxxxxxxxxxxxx
Date: Tue, 21 Dec 2004 09:59:02 -0000
Can only speak from Solaris and Linux, but I do this (just a dump of
my rough notes):
==========================================================================
EXP-00041: Export done in server's WE8DEC, different from user's
character set US7ASCII
EXP-00000: Export terminated unsuccessfully
You need to reset your shell vars:
Get the correct database settings:
SQL> select value$ from props$ where name in
('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET');
VALUE$
----------------------------------------------------------------------------
----
AMERICAN
AMERICA
WE8DEC
Now set the shell vars correctly:
export NLS_LANG=AMERICAN_AMERICA.WE8DEC
Regards
Taj
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
