Home » RDBMS Server » Server Utilities » IMP-00037: Character set marker unknown (Import: Release 9.2.0.4.0)
|
|
|
|
|
|
Re: IMP-00037: Character set marker unknown [message #314264 is a reply to message #314261] |
Wed, 16 April 2008 04:18   |
 |
Michel Cadot
Messages: 68757 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
anacedent wrote on Tue, 15 April 2008 06:08 | 00037, 00000, "Character set marker unknown"
// *Cause: The export file is corrupted.
// *Action: Try to obtain an uncorrupted version of the export file.
// If the export file is not corrupted, report this as an Import
// internal error and submit the export file to customer support.
[oracle@amo01dn ~]$
|
[Updated on: Wed, 16 April 2008 04:18] Report message to a moderator
|
|
|
|
|
Re: IMP-00037: Character set marker unknown [message #314540 is a reply to message #314499] |
Thu, 17 April 2008 01:57   |
 |
Littlefoot
Messages: 21824 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Oh! So you'd like to know which version of EXP.EXE they have used?!?
One way is to run IMPORT with SHOW=Y option; it won't actually import anything, but will display some useful information (I'm using [quote] tags on purpose; [code] wouldn't allow me to emphasize the important part):Quote: | M:\>imp scott/tiger@ora10 file=scott.dmp show=y
Import: Release 10.2.0.1.0 - Production on ╚et Tra 17 08:51:09 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.02.01 via conventional path
import done in EE8MSWIN1250 character set and AL16UTF16 NCHAR character set
. importing SCOTT's objects into SCOTT
|
Another way is to open export file using any editor capable of opening such a (large?) file (if on MS Windows, Notepad perhaps won't be able to do that). Or, type the beginning of the export file to the screen. Whichever method you use, the very first line of the export file matters. It will show you something like♥ �EXPORT:V10.02.01 orČCČ�ČAEXPORT:V07.01.05<LF> (rubbish, mostly), but it doesn't matter as you'll probably see what matters: the first one was done using EXP version 10.2.1, the second one with EXP 7.1.5.
Perhaps there's another, more sophisticated way to do that, but I don't know it.
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Wed May 21 05:33:37 CDT 2025
|