Home » RDBMS Server » Server Administration » Exporting tables with a specific character set
Exporting tables with a specific character set [message #56784] Thu, 24 April 2003 10:12
Ahmed Ramadan
Messages: 3
Registered: March 2003
Junior Member
Hello,

I have an Oracle database installed in a Unix system and I have another one installed in a Windows2000 system. I have used the Exp tool provided by the database to export a table in a binary format file. the Export done in a US7ASCII char set. then I have used the Imp tool to import the table into the windows based databse. I have 2 fields on the database one for the Name and the other for the address. These 2 fields are in Arabic but when I was viewing these 2 fields All I see is English characters not related to each other. So is it a problem in the char set or what?
Can I specify the char set with exp tool or the imp tool?
how can I know the char set used by the database in the Unix envirnment using the sql plus?

please I need help ASAP.

Kind Regards,
Ahmed
Previous Topic: Question
Next Topic: Shrinking - need room on computer
Goto Forum:
  


Current Time: Fri Sep 20 09:27:39 CDT 2024