Philip Silouan Thompson wrote:
> 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_at_go180.net
> System Administrator
> OneEighty Networks
>
>
Check the NLS_ settings on both sides, and make sure the
dev server has the same as the prod server, even if only
for the import session (e.g. set it manually)
--
Regards, Frank van Bortel
Received on Fri Oct 31 2003 - 02:50:34 CST
