Export 8i (8859p1) to 9i (AL32UTF8)

Hi,

I try to transfert data from a database 9i (AL32UTF8) to a database 8i (we8iso8859p1)

After exporting from 9i, transfert through ftp/bin I try to import on 8i, it doesn't work with the two charset I tried:

oracle_at_daisy:/oracle/backup$ export NLS_LANG=american_america.we8iso8859p1 oracle_at_daisy:/oracle/backup$ imp system file=patentdev.dmp fromuser=patentdev>

Import: Release 8.1.7.4.0 - Production on Fri Jun 18 16:04:40 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Password:

Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option
JServer Release 8.1.7.4.0 - Production

IMP-00038: Could not convert to environment character set's handle IMP-00000: Import terminated unsuccessfully

oracle_at_daisy:/oracle/backup$ export NLS_LANG=american_america.utf8 oracle_at_daisy:/oracle/backup$ imp system file=patentdev.dmp fromuser=patentdev>

Import: Release 8.1.7.4.0 - Production on Fri Jun 18 16:05:13 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Password:

Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option
JServer Release 8.1.7.4.0 - Production

IMP-00038: Could not convert to environment character set's handle IMP-00000: Import terminated unsuccessfully

I tried to export 9i from the 8i exp bin but I had the follownig error:

oracle_at_daisy:/oracle/backup$ exp system_at_DB9IDEV file=patentdev.dmp log=exp_pa>

Export: Release 8.1.7.4.0 - Production on Fri Jun 18 16:05:47 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Password:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production
Export done in UTF8 character set and UTF8 NCHAR character set server uses AL32UTF8 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user PATENTDEV
. exporting object type definitions for user PATENTDEV
About to export PATENTDEV's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export PATENTDEV's tables via Conventional Path ...

EXP-00008: ORACLE error 904 encountered
ORA-00904: "SPOLICY": invalid identifier
EXP-00000: Export terminated unsuccessfully

How can do that ????
Thanks in advance Received on Sat Jun 19 2004 - 03:35:00 CDT