Hello all,

I have a very weird situation which i would appreciate any help I could get.

I was called in to support an oracle client to solve a problem they were facing, here is a brief description.

Due to a misconfigured client, they managed to have a AR8ISO8859P6 character set database hold a table with AR8MSWIN1256 character set!!

The problem is that I couldnt find a way to convert the table since oracle considers it to be AR8ISO although in fact it is AR8MSWIN.

The only solution i found on the net was to hex edit the dump file, which only partially worked since I do not have the exact locations of the character set markers found in the dump file (there is more than one for sure).

Does anyone know of a way around this??

Regards,
Khalid