Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Character set marker unknown

RE: Character set marker unknown

From: Ian Cary (C) <Ian.Cary_at_ordnancesurvey.co.uk>
Date: Mon, 7 Nov 2005 15:16:47 -0000
Message-ID: <4AA808D68343824E8891632BD448AE6B1BEBFF@OSMAIL.ordsvy.gov.uk>


When you say "got a dump file" how exactly did you get it. This error is often caused by not using binary mode ftp to transfer a file or by some zip / unzip error.  

Regards,  

Ian

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Onkar N Tiwary Sent: 07 November 2005 14:58
To: oracle-l_at_freelists.org
Subject: Character set marker unknown

hi guys,  

today we had got a dump file from the client for importing two tables in the database containing somwhere more than 1 million records in each. When i invoked imp utility on the database , i am getting the error :  

IMP-00037 : Character set marker unknown  

os & db info:  

Windows 2000 Adv. Server
Db : Oracle 9i rel 2 ( 9.2.0.6 target 9.2.0.4 source) Character set : Export done in US7ASCII character set and AL16UTF16 NCHAR character set -- source

                       server uses WE8ISO8859P1 character set   -- target
 
 

I tried on metalink and they say might be dump file corrupted but client says they can import from the same dump file without error.  

Any Idea??????????????

--

Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.

       to_onkar_at_yahoo.com
       onkarnath.tiwary_at_gmail.com
 


This email and any attachments have been virus checked upon receipt at Ordnance Survey and are free of all known viruses.

This email is only intended for the person to whom it is addressed and may contain confidential information. If you have received this email in error, please notify the sender and delete this email which must not be copied, distributed or disclosed to any other person. Unless stated otherwise, the contents of this email are personal to the writer and do not represent the official view of Ordnance Survey. Nor can any contract be formed on Ordnance Survey's behalf via email. We reserve the right to monitor emails and attachments without prior notice.

Thank you for your cooperation.

Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000
http://www.ordnancesurvey.co.uk

--

http://www.freelists.org/webpage/oracle-l Received on Mon Nov 07 2005 - 09:19:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US