|
|
|
|
|
|
|
|
|
|
|
|
| Re: IMP-00037: Character set marker unknown [message #314264 is a reply to message #314261] |
Wed, 16 April 2008 04:18   |
 |
Michel Cadot
Messages: 68645
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 #314499 is a reply to message #314358] |
Wed, 16 April 2008 23:15 |
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 |
 |
Littlefoot
Messages: 21808
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 #315861 is a reply to message #315854] |
Wed, 23 April 2008 00:58 |
|
Michel Cadot
Messages: 68645
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
