exp/imp with different character set
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: exp/imp with different character set

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    exp/imp with different character set

    I got the dump file that was exported using US7ASCII and my database is WE8ISO8859P1. what do I need to do to import this dump file into my database without having any problems???

    thanks

  2. #2
    Join Date
    Dec 2002
    Location
    USA
    Posts
    53
    No problem.

  3. #3
    Join Date
    Sep 2002
    Posts
    411
    how do you do it ???

    what do you need to do ???

  4. #4
    Join Date
    Dec 2002
    Location
    USA
    Posts
    53
    Just do regular import and Oracle will automatically convert chars during import.

  5. #5
    Join Date
    Jan 2002
    Posts
    474
    no it won't

  6. #6
    Join Date
    Mar 2001
    Posts
    144
    Sometimes it will sometimes it won't. Depends on the charactersets - if the export is a subset of the characterset in the target database then the binaries will attempt to convert. Otherwise you will need to switch the characterset on the during the export.

    For example:

    I am assuming a Unix type machine. Under windows I think you will need to change a registry key or something but I am not sure.

    1) change the environment variable of NLS_LANG to that of your target database:

    echo $NLS_LANG
    export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859
    echo $NLS_LANG
    AMERICAN_AMERICA.WE8ISO8859P1

    2) do your export. You should see something like this before the data starts to get exported:

    Export done in WE8ISO8859P1 character set and UTF8 NCHAR character set
    server uses UTF8 character set (possible charset conversion)

    3) now you should be able to import the dmp file into your target database.

    Conversely you can do this on the import too. Change the NLS_LANG variable before importing and this should convert the dmp file but I personally think it's easier doing this on the export.

    In Windows (dos really) you do:

    set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

    Then do the export.

    HTH
    You want to do what? When? Where?!
    Oy vay!

  7. #7
    Join Date
    Sep 2002
    Posts
    411
    I am aware of this but the question is what if I already had the dump file that was exported from the US7ASCIIn abd now how am I supposed to import it into the existing database

  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    As you've allready been told by supower, you shouldn't have any difficulties - simply import it, that's it.

    If you are not sattisfied with supower's answer, it would be nice of you and ashley75 if you provide us with some details, like OS, Oracle release, imp command you are using, error messages you are geting, etc ....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  9. #9
    Join Date
    Mar 2001
    Posts
    144
    http://metalink.oracle.com/metalink/...1&p_showHelp=1

    US7ASCII is a subset of WE8ISO8859P1 so the binaries will convert it on it's own.

    http://metalink.oracle.com/metalink/...1&p_showHelp=1
    You want to do what? When? Where?!
    Oy vay!

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by mike2000
    I am aware of this but the question is what if I already had the dump file that was exported from the US7ASCIIn abd now how am I supposed to import it into the existing database
    mike2000 or ashley75 do you peeps ever go to do some research yourselves by reading docs and webbing metalink? if you want to do some serious job you might as well start to do so

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width