Home » RDBMS Server » Server Utilities » CHARACTER SET CONVERSION PROBLEM (ORACLE 10G RELEASE 10.2.0.3.0 ON WIN 7 PROFESSIONAL)
CHARACTER SET CONVERSION PROBLEM [message #482556] Fri, 12 November 2010 08:54 Go to next message
mosesisack@hotmail.com
Messages: 1
Registered: November 2010
Location: Dar es salaam, Tanzania
Junior Member
Hi guys!

I am trying to import a dump into my oracle 10.2.0.3.0 database on my win 7 professional laptop. The dump is exported from my win xp desktop pc running Oracle 10.2.0.1.0

Below is the error i get:

Import: Release 10.2.0.3.0 - Production on Fri Nov 12 15:57:52 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Username: system/password@orcl

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

Import file: EXPDAT.DMP > F:\Personal\DPISIMBA.dmp

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V10.02.01 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no >

Ignore create error due to object existence (yes/no): no >

Import grants (yes/no): yes >

Import table data (yes/no): yes >

Import entire export file (yes/no): no >
Username:paymaster

Enter table<T> or partition<T:P> names. NULL list means all tables for user
Enter table<T> or partition<T:P> name or . if done:


when I press enter key, the console hangs and a window appears with "Console Window Host has stopped working" then the console closes prematurely.

what can i do to fix this issue?

moses


Re: CHARACTER SET CONVERSION PROBLEM [message #482558 is a reply to message #482556] Fri, 12 November 2010 09:12 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>what can i do to fix this issue?
Any clues in the alert_SID.log file?
Any clues in OS system log file?
Previous Topic: Re: SQLLDR, dates and null columns
Next Topic: data pump import order - causing constraint violation
Goto Forum:
  


Current Time: Sun Sep 19 20:58:59 CDT 2021