Home » RDBMS Server » Server Utilities » IMP-00037: Character set marker unknown (Import: Release 9.2.0.4.0)
IMP-00037: Character set marker unknown [message #313855] Mon, 14 April 2008 23:05 Go to next message
rukmambara_babu
Messages: 15
Registered: April 2008
Junior Member
I am getting this error:
IMP-00037: Character set marker unknown. what is the best solution for this error?
PLs help for resolving the issue.
thx
Re: IMP-00037: Character set marker unknown [message #313857 is a reply to message #313855] Mon, 14 April 2008 23:08 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
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 ~]$ 


I have seen this error when the wrong version imp utility is used
Re: IMP-00037: Character set marker unknown [message #313864 is a reply to message #313857] Mon, 14 April 2008 23:46 Go to previous messageGo to next message
rukmambara_babu
Messages: 15
Registered: April 2008
Junior Member
how do i find the version of imp
Re: IMP-00037: Character set marker unknown [message #313867 is a reply to message #313864] Mon, 14 April 2008 23:48 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
> IMP HELP=Y
will, among other information, display utility version.
Re: IMP-00037: Character set marker unknown [message #313878 is a reply to message #313867] Tue, 15 April 2008 00:18 Go to previous messageGo to next message
rukmambara_babu
Messages: 15
Registered: April 2008
Junior Member
how do i find the version of EXP. I requested them to send us the exportlog file.
Re: IMP-00037: Character set marker unknown [message #314261 is a reply to message #313878] Wed, 16 April 2008 04:03 Go to previous messageGo to next message
rukmambara_babu
Messages: 15
Registered: April 2008
Junior Member
We got the same error using import with version ORACLE 10 also..
Re: IMP-00037: Character set marker unknown [message #314264 is a reply to message #314261] Wed, 16 April 2008 04:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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 #314358 is a reply to message #313878] Wed, 16 April 2008 07:58 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
previous messages

Q: how do i find the version of imp

A: IMP HELP=Y will, among other information, display utility version

Q: how do i find the version of EXP


A: If you guess the answer, I'll buy you a chocolate.
Re: IMP-00037: Character set marker unknown [message #314499 is a reply to message #314358] Wed, 16 April 2008 23:15 Go to previous messageGo to next message
rukmambara_babu
Messages: 15
Registered: April 2008
Junior Member
my query is about the EXP version.EXP was done by third party.Hence I don't know the ORACLE version they are running. that is the reason I am requesting the EXP log file from third party.please excuse me ,if the discussion is very fundamental about ORACLE EXP/IMP.
thanks,
Re: IMP-00037: Character set marker unknown [message #314540 is a reply to message #314499] Thu, 17 April 2008 01:57 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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.
Re: IMP-00037: Character set marker unknown [message #315292 is a reply to message #314540] Sun, 20 April 2008 20:56 Go to previous messageGo to next message
rukmambara_babu
Messages: 15
Registered: April 2008
Junior Member
Please reply "Import terminated successfully with warnings" --indicates NO ERRORS in IMPORT.

[Updated on: Sun, 20 April 2008 20:57]

Report message to a moderator

Re: IMP-00037: Character set marker unknown [message #315297 is a reply to message #315292] Mon, 21 April 2008 00:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Please reply "Import terminated successfully with warnings" --indicates NO ERRORS in IMPORT.

NO, it indicates ERRORS on import.

Regards
Michel
Re: IMP-00037: Character set marker unknown [message #315842 is a reply to message #315297] Tue, 22 April 2008 23:32 Go to previous messageGo to next message
rukmambara_babu
Messages: 15
Registered: April 2008
Junior Member
pls let me know ,why there is no ORALCE error number listed for this error.the data import seems to be OK.pls clarify asap.
thanks ahead. Cool
Re: IMP-00037: Character set marker unknown [message #315851 is a reply to message #315842] Wed, 23 April 2008 00:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
IMP-00037, is this not an Oracle error?

Regards
Michel
Re: IMP-00037: Character set marker unknown [message #315854 is a reply to message #315851] Wed, 23 April 2008 00:35 Go to previous messageGo to next message
rukmambara_babu
Messages: 15
Registered: April 2008
Junior Member
that was an earlier error regarding the import..
I am confusing you by combining the two issues.
NOW THE IMPORT IS COMPLETED BUT I GOT THE MESSAGE:
"IMPORT COMPLETED SUCCESSFULLY WITH WARNINGS."
PLS REPLY ASAP
Re: IMP-00037: Character set marker unknown [message #315861 is a reply to message #315854] Wed, 23 April 2008 00:58 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I am confusing you by combining the two issues.

This is why you must not post several questions in the same topic.
Now the next one who read this because he has an IMP-00037 error will not understand or hardly find what is related to one question or the other.

Quote:
NOW THE IMPORT IS COMPLETED BUT I GOT THE MESSAGE:
"IMPORT COMPLETED SUCCESSFULLY WITH WARNINGS."

And then?

Regards
Michel
Previous Topic: create db
Next Topic: How to import schema of oracle10 to oracle9?
Goto Forum:
  


Current Time: Sat Dec 03 01:24:41 CST 2016

Total time taken to generate the page: 0.14159 seconds