| character set mismatching in import [message #289665] |
Tue, 25 December 2007 02:38  |
Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA
|
Member |
|
|
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  |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
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 |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
please..............read ........... the .............. link .............. I ............. posted and................ tell............... why ............. it ............. does.............not ..... help..... you.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
