Oracle SQL Developer is a free, graphical tool that makes it so much easier to work with Oracle databases that we think you should use it right from the start. So this chapter shows you how to use SQL Developer to work with database objects and to build and run SQL statements. An Oracle character set defines a group of characters with the following common features. same region of the world; same encoding; same code point map; The following table contains a sample of Unicode character sets available in a Oracle database as well as some older character sets commonly used before Unicode was invented.
Syntax as follow, change the character set to your database’s character set. export NLS_LANG=WE8ISO8859P1. For easier way of resolution, export with option “STATISTICS=NONE”. Also, if you’re using Oracle 10g, use Oracle Date Pump’s expdp and impdp instead of instead of exp and imp to export and import the data.