*note: used "exp80" and "imp80" of the 805 DB to get the data
from: 817 on NT
to: 805 on UNIX
my export log:
Connected to: Oracle8i Enterprise Edition Release 22.214.171.124.1 - Production
With the Partitioning option
JServer Release 126.96.36.199.1 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
my import ERROR log:
D:\oracle\ora81\bin>imp80 system/manager@psiqa2 parfile=c:\temp\spools\psiqa2_admin.par
Import: Release 188.8.131.52.0 - Production on Mon Dec 24 11:55:59 2001
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Connected to: Oracle8 Enterprise Edition Release 184.108.40.206.0 - Production
PL/SQL Release 220.127.116.11.0 - Production
IMP-00037: Character set marker unknown
IMP-00000: Import terminated unsuccessfully
so, do I need to do a DIFFERENT export?
setting the nls_lang?
I am not too familiar with how to do this.
If you have access to oracle's metalink here is a good article to read. I think what you are experiencing can be resolved by this article. It could also be that your export file may be corrupted if it was ftp'd.
Doc ID: Note:132904.1
Subject: Compatibility Matrix for Export & Import Between Different Oracle Versions
Content Type: TEXT/PLAIN
Creation Date: 19-JAN-2001
Last Revision Date: 31-AUG-2001
This article describes several issues related with the compatibility of the
different versions of the Oracle EXPORT and IMPORT utilities.