| Oracle Export - Character set issue [message #57685] |
Mon, 30 June 2003 12:38 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
