PDA

View Full Version : IMP-00037: Character set marker unknown


Philip Silouan Thompson
10-30-2003, 12:42 PM
Hello all,

I just did a full export from Oracle 8.1.7 on Solaris 8. The export
terminated successfully without warnings and I got a ~1.3GB .dmp file as I
expected. I didn't use any compression. I FTP'd the .dmp file to my dev
server and ran imp, which says:

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

I re-ran the export, again FTP'd the file in binary mode, and got the same
result again.

A few days ago I was able to import a file exported form this same database.
Is there something that would cause a database to begin producing only
corrupted export files?

Any ideas would be appreciated!

Thanks,

Phil Thompson
pthompson@go180.net
System Administrator
OneEighty Networks

Chris Leonard
11-03-2003, 09:21 AM
I think that when you get this error using an export file that is known to
not be corrupt, they you are supposed to start an TAR and submit the export
file to Oracle (if possible). Of course, you can't be absolutely sure that
the export file is not corrupt, but since you've tried a number of different
times and are still having problems, I'd consider starting an TAR on
MetaLink.

--
Cheers,
Chris

___________________________________

Chris Leonard, The Database Guy
http://www.databaseguy.com

Brainbench MVP for Oracle Admin
http://www.brainbench.com

MCSE, MCDBA, OCP, CIW
___________________________________

"Philip Silouan Thompson" <pthompson@go180.net> wrote in message
news:vq2tvkhi7o8ce@corp.supernews.com... Hello all, I just did a full export from Oracle 8.1.7 on Solaris 8. The export terminated successfully without warnings and I got a ~1.3GB .dmp file as I expected. I didn't use any compression. I FTP'd the .dmp file to my dev server and ran imp, which says: IMP-00037: Character set marker unknown IMP-00000: Import terminated unsuccessfully I re-ran the export, again FTP'd the file in binary mode, and got the same result again. A few days ago I was able to import a file exported form this same
database. Is there something that would cause a database to begin producing only corrupted export files? Any ideas would be appreciated! Thanks, Phil Thompson pthompson@go180.net System Administrator OneEighty Networks


MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service