OraFAQ Forum: Server Utilities » Oracle Export

Home » RDBMS Server » Server Utilities » Oracle Export - Character set issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Export - Character set issue [message #72499]

Mon, 30 June 2003 12:37

Tony
Messages: 190
Registered: June 2001

Senior Member

Hi,
I was trying to export a table in a specific oracle database (which is in WE8MSWIN1252 character set) and I'm getting trouble: Following is the steps:

$exp
Export: Release 8.1.7.0.0 - Production on Mon Jun 30 11:14:52 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Username: system
Password:

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp > expdat.dmp

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 3

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in US7ASCII character set and WE8MSWIN1252 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > [[RETURN]]

Export terminated successfully without warnings.

$setenv NLS_LANG WE8MSWIN1252
$echo $NLS_LANG
WE8MSWIN1252

$exp

Export: Release 8.1.7.0.0 - Production on Mon Jun 30 11:16:04 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Username: system
Password:

EXP-00056: ORACLE error 12705 encountered
ORA-12705: invalid or unknown NLS parameter value specified

Help Please!!!

Thanks

Report message to a moderator

Re: Oracle Export - Character set issue [message #72502 is a reply to message #72499]

Tue, 01 July 2003 06:03

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

try to just continue with export WITHOUT setting the NLS_LANG.
As export tool says, most of charactersets are subject to autoconversion.
If you cannot import this into target,
then, we will find someworkaround

Report message to a moderator

Re: Oracle Export - Character set issue [message #73143 is a reply to message #72502]

Sun, 15 February 2004 03:48

Naimdjon
Messages: 2
Registered: February 2004

Junior Member

I am getting the same problem now. It was working quite nice and we have a batch job that exports users every night but suddenly I get the error message.could not find anything that could explain on the net:

Connected to: Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
Enter array fetch buffer size: 4096 >

Export file: EXPDAT.DMP > newdump.dmp

(2)U(sers), or (3)T(ables): (2)U >

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully

Report message to a moderator

Re: Oracle Export - Character set issue [message #73373 is a reply to message #73143]

Mon, 05 April 2004 03:39

Thiyag
Messages: 1
Registered: April 2004

Junior Member

Do you have a locally created system table in the schema you are trying to export. (DUAL,USER_TABLES etc?). In that case export would expect records to be present in these the local system tables.

Report message to a moderator

Re: Oracle Export - Character set issue [message #73374 is a reply to message #73373]

Mon, 05 April 2004 04:32

Naimdjon
Messages: 2
Registered: February 2004

Junior Member

Yes. I just checked it in and it seems ok.
Actually I did test several techniques and very strange. When I run an export with .bat file, it seems to work well...

Report message to a moderator

Previous Topic:	Problem converting dates with SQL Loader
Next Topic:	Error in using SQLLDR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 20:05:34 CST 2024