Database Utilities (MOSC)

MOSC Banner

Import data in the different character set

edited Jun 20, 2018 4:49PM in Database Utilities (MOSC) 10 commentsAnswered
 Hi,

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center