character set mismatching in import [message #289665] |
Tue, 25 December 2007 02:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Vivek.k.thakur
Messages: 30 Registered: December 2007 Location: DELHI, INDIA
|
Member |
![vivek_13111980%40yahoo.co.in](/forum/theme/orafaq/images/yahoo.png)
|
|
Hi Experts,
while I am Importing data from export dump , I am getting following message. Plese suggest me what should I do? while I am changing character set its giving the message-ORA-12712: new character set must be a superset of old character set
G:\>imp imis/imis file=pv.dmp log=pv.log fromuser=imis touser=imis
Import: Release 10.1.0.4.2 - Production on Tue Dec 25 13:22:39 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export file created by EXPORT:V09.02.00 via direct path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00003: ORACLE error 2248 encountered
ORA-02248: invalid option for ALTER SESSION
IMP-00000: Import terminated unsuccessfully[/COLOR]
|
|
|
Re: character set mismatching in import [message #289667 is a reply to message #289665] |
Tue, 25 December 2007 03:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |
![star_taj%40yahoo.com](/forum/theme/orafaq/images/yahoo.png)
|
|
Hi,
What is export dump file version ?
1. use same export and import binary for export & import database.
2. it is not related to database characterset (import error)
3. don't change database characterset otherwise you getting ORA-12712 ERROR.
ORA-12712: new character set must be a superset of old character set
Cause: When you ALTER DATABASE ... CHARACTER SET, the new character set must be a superset of the old character set. For example, WE8ISO8859P1 is not a superset of the WE8DEC.
Action: Specify a superset character set.
[Updated on: Tue, 25 December 2007 03:11] Report message to a moderator
|
|
|
|
|
|
Re: character set mismatching in import [message #289680 is a reply to message #289678] |
Tue, 25 December 2007 05:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
please..............read ........... the .............. link .............. I ............. posted and................ tell............... why ............. it ............. does.............not ..... help..... you.
Regards
Michel
|
|
|