Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Lightbulb Unanswered: How can I export whole database from Unix to Windows 2000

    I have production database in Unix. I am taking daily export from Unix Database. I want to import that DMP in Windows 2000/NT.

    It is giving me message that CharacterSet is different. How can I take import?

    I am waiting for reply.


  2. #2
    Join Date
    Sep 2003
    The Netherlands

    your problem is not the OS but the environment settings.
    Normally u export the db on UNIX and FTP it to Windows (be sure use the binary option !) and then import it in the new db.
    The message about the characterset says something like export done in ... server uses ....
    U can avoid that mesage by setting the nls_lang to the same as the characterset which was used for soing the export by typing :
    set NLS_LANG=<neededcharacterset>
    in the same session/dos box in which u do the import.

    But normally the import end succesfully without any warnings. it's just to warn u that character conversions might be possible because there's a difference between the set used to export and the set to import. It all depends on the two charactersets if any conversion are made or likely to be made. For example, if u go from american_america.WE8ISO8859P1 to american_america.WE8ISO8859P15 it is not likely that conversion are to be made. But going to USASCII7 changes will be made.

    Hope this helps.
    Edwin van Hattem
    OCP DBA / System analyst

Posting Permissions

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