Question

Import Charset....

Rating6.4Good

I'm importing an file exported from a 8.1.6 db into an Oracle 9.0.1.4 system. I've set both databases to use the WE8ISO8859P1 charset. When i import this file into the 9i release i get this message...

Connected to: Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production
JServer Release 9.0.1.4.0 - Production

Export file created by EXPORT:V08.01.06 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses WE8ISO8859P1 character set (possible charset conversion)
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)

I can understand the NCHAR charset conversion but why am i getting the message 'import done in WE8MSWIN1252 character set', when i've set to use WE8ISO8859P1??

  1. full import failed - DBMS error
    hi i am trying to import full dump of customer, version 9.2.0.8 i get this error, can yu help? Connected to: Oracle9i Release 9.2.0.8.0 - Production JServer Release 9.2.0.8.0 - Production Export file created by EXPORT:V09.02.00 via conventional path import done in WE8ISO8859P1 character …
  2. Location of import error messages
    I tried to import unsucessfully. What is the location of the log file or error file with the messages? Export file created by EXPORT:V09.02.00 via conventional path import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses WE8ISO8859P1 character set (possible charset conversion) "…
  3. problem when import to dmp file invalid option alte…
    hello, i tried to import to a dmp file and present this error D:\gerid\Surtigas>imp system/system@intranet file=vimacv10.dmp fromuser=vimac touser=vimacsurti Import: Release 10.1.0.2.0 - Production on Wed Feb 21 12:30:36 2007 Copyright (c) 1982, 2004, Oracle. All rights reserve…
  4. Problems with IMPORTING .dmp files
    Hi, I have 2 Oracle 9i databases. I'm trying to import the .dmp fiel from one to another. However, when I run the Import, I get the following output Import: Release 9.2.0.7.0 - Production on Lun Jun 26 13:07:35 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Usern…
  5. Unicode on Ora 10 question
    Hi Experts 1. i have installes server of oracle 10.2.0.4 without client. 2. i created an nstance with Unicode AL32UTF8 and charset UTF8. 3. i do an export to dump file. 4. in the log of export i see: Export done in WE8MSWIN1252 character set and UTF8 NCHAR character set server uses AL32UTF8 character set …

Solution

Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.

About this Solution
View This Solution - Start Your 30 Day Free Trial
Zone
General
Tags
character set import charset
Participating Experts
1
Solution Grade
C

Replies

 
by:

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: impoole

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Stay Connected

Oracle Around the Web

The latest Oracle news, tips, and tricks

Oracle Unveils Netra SPARC T3 Servers

New Carrier-Grade Blade and Rackmount Servers Deliver Better Performance, Density and Power Efficiency for the Communications Industry ...

read more

Oracle fixes 21 flaws in Java SE, Java for Business

Oracle is fixing 21 flaws in its Java SE and Java for Business products in its February critical patch update issued this week ...

read more

Obama’s Silicon Valley “Tech Supper”

Why was he there? Who wasn’t invited and why? What did they talk about? Why was he really there? These are the questions being debated ...

read more

Featured Oracle Experts

slightwv

slightwv has answered more than 2,000 Oracle questions and oversees database management within the U.S. Government. Slightwv

sdstuber

A regular presenter at the Collaborate conference, Oracle developer sdstuber is a top expert in PL/SQL and Oracle 9, 10 and 11. sdstuber

Testimonials

What users are saying about our experts

"The Oracle gurus provide answers, solutions and valuable workarounds"

User: schwertner

"Wow! Excellent, valuable explanation. Hats off to you"

User: aseshu70

"Solution worked fantastic and performs excellent! Thanks heaps"

User: klausbrandlhuber

Top Experts

  1. slightwv

    2,000

    0 points yesterday

    Profile

BrowseBecome an Expert