Home » RDBMS Server » Server Utilities » IMP-00037: Character set marker unknown (2 threads merged by bb) (Oracle 11 import)
IMP-00037: Character set marker unknown (2 threads merged by bb) [message #496841] Wed, 02 March 2011 13:29 Go to next message
Kums
Messages: 1
Registered: March 2011
Location: PA
Junior Member
Hi All,

When I am trying to import a dump file which was exported from Oracle 10.2.0.4(installed on Solaris) in to Oracle 11.1.0.6.0(Installed on Windows 2003), I am getting the following error

IMP-00037: Character set marker unknown
IMP-00000: Import terminated unsuccessfully

So , I have couple of questions on this

1. Is the above import operation is supported?
2. If yes , which is actually causing the problem?
3. How to rectify this problem? - any solution or workarounds?
4. What should I check in both the Oracle instances - any specific parameters or configurations

Awaiting your help and inputs on this

Thanks a lot in advance
Re: IMP-00037: Character set marker unknown [message #496843 is a reply to message #496841] Wed, 02 March 2011 13:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
IMP-00037: 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.


Did you tranfer the file in binary mode?

Regards
Michel
Re: IMP-00037: Character set marker unknown [message #496845 is a reply to message #496841] Wed, 02 March 2011 13:38 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
bcm@bcm-laptop:~$ oerr IMP 37
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.

[Updated on: Wed, 02 March 2011 13:39]

Report message to a moderator

Previous Topic: SQL Loader and Escape Characteres
Next Topic: remove all dependencies on tablespace
Goto Forum:
  


Current Time: Mon Dec 23 11:40:14 CST 2024