export/import issues
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: export/import issues

Hybrid View

  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218

    Question export/import issues

    Hi , I seem to be having import issues but I am not really sure whether I have a problem. I have received an export dump file and log with the following info: "Export done in US7ASCII character set and WE8MSWIN1252 NCHAR character set, server uses WE8MSWIN1252 character set (possible charset conversion)"

    When I do the import on my server, I get the following msg:
    "import done in WE8MSWIN1252 character set and WE8MSWIN1252 NCHAR character export client uses US7ASCII character set (possible charset conversion)" .

    Why am I getting a "possible charset conversion" on my import?

    If I querry both servers(export and import servers), the same character sets are used.

    PARAMETER VALUE
    ------------------------------ -------------
    NLS_CHARACTERSET WE8MSWIN1252
    NLS_NCHAR_CHARACTERSET WE8MSWIN1252

    The entire schema is imported sucessfully with the exception on a create index problem. Is this caused by the possible charset conversion? Do I need to change the NLS values to avoid a char conversion? Maybe I do not not have an issue here? Please advise and thank you.

  2. #2
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    I think US7ASCII character set is a subset of your importing character set, so you should be fine!
    roukie-dba

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