Home » RDBMS Server » Server Utilities » changing char set imp-00037 error (windows oracle 10g)
changing char set imp-00037 error [message #379964] Thu, 08 January 2009 12:22 Go to next message
Monica
Messages: 37
Registered: February 2000
Member
I have a 10g database using AMERICAN_AMERICA.WE8MSWIN1252 and I want to change to CHARACTER SET AL32UTF8 ,NATIONAL CHARACTER SET al16utf16.

I exported the database, deleted datafiles and created database with
CREATE DATABASE proddb
... CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16

when I go to import I get imp-00037 character set marker unknown. I have tried setting NLS_LANG at the DOS prompt before importing but no luck.

Suggestions?

Report message to a moderator

Re: changing char set imp-00037 error [message #379985 is a reply to message #379964] Thu, 08 January 2009 17:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I would not have applied these brute force methods before doing some research.


http://www.oracle-base.com/articles/10g/CharacterSetMigration.php
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14225/ch11charsetmig.htm

>>I exported the database, deleted datafiles and created database with
Did you really blow away the source database?
Did you transfer the dump file?
Are you sure the file is not corrupted?
Post the complete error message.

Report message to a moderator

Re: changing char set imp-00037 error [message #379986 is a reply to message #379964] Thu, 08 January 2009 17:22 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Most probably, your dump file is corrupt.

Report message to a moderator

Previous Topic: how to specify log files for exporting and importing logical objects
Next Topic: Migrating Oracle 10g from Windows XP to Linux
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 28 09:01:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.