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.
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.