Import data in the different character set
I have an export dump file from characterset WE8ISO8859P1 and I need to import data into another schema which the characterset is AL32UTF8
I have tried to set the NLS_CHARACTERSET AMERICAN_AMERICA.WE8ISO8859P1 before import data but still received ora-01461
"Connected to: Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
With the Real Application Clusters option
Export file created by EXPORT:V10.01.00 via conventional path
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export client uses US7ASCII character set (possible charset conversion)