1 Reply Latest reply on Feb 19, 2013 6:41 AM by Kgronau-Oracle

    Data Migration from WE8MSWIN1252 to AR8MSWIN1256.

      Similar case

      I have Arabic data stored into below two encodings in oracle AL32UTF8 database

      1 Million rows into WE8MSWIN1252
      .5 million rows into AR8MSWIN1256

      in all cases I like to convert 1 Million row of WE8MSWIN1252 into AR8MSWIN1256. I tried using SQLdeveloper is works.
      But no luck using oracle export/import utility (both exp and expdp)…. I’m thinking may be certain locale is required for export/import to work.

      I need to convert only 1 table not the entire database.

      Also my company said SQL developer is free utility may not be supported by oracle so use export and import for this, any input/suggestion would be appreciated.

      Edited by: 988626 on Feb 18, 2013 12:40 AM
        • 1. Re: Data Migration from WE8MSWIN1252 to AR8MSWIN1256.
          This forum is for migrations of foreign databases to Oracle. You're asking for assistance for a NLS related issue. There's a dedicated forum dealing with NLS related issues. As I can't move your thread to the Globalization Forum "https://forums.oracle.com/forums/forum.jspa?forumID=50" or to Export/Import "https://forums.oracle.com/forums/forum.jspa?forumID=732", please close this one and open a new one in the matching forum.