Re: Export data from 10g into 9i

From: Beckstrom Jeffrey <JBECKSTROM_at_gcrta.org>
Date: Tue, 26 Jan 2016 15:25:49 -0500
Message-Id: <56A78FFD0200000B0000B7B7_at_groupwise2014.gcrta.org>

You have to run 9i export against the 10g database. The version of the export dump has to match the version of the database you will be importing to.

>>> Jimmy Brock <jimmybrock_at_gmail.com> 1/26/16 3:16 PM >>>
Target: Oracle 9i Release 2 (Production server) Source: Oracle 10g Release 2 (Stage server)

On 10g I used EXP to export data. When importing into 9i I get an error: IMP-00010: not a valid export file, header failed verification IMP-00000: Import terminated unsuccessfully

So i used SCP to copy the Oracle 9i EXP tool over to the 10g server. Now I encountered this error: EXP-00056: ORACLE error 12705 encountered ORA-12705: Cannot access NLS data files or invalid environment specified

At this point I logged into the Oracle 9i and did a small export to see what the NLS setttings were: Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion)

So on the 10g server I modified the NLS_LANG setting: export NLS_LANG=AMERICAN_AMERICA.US7ASCII

Now I get this error:
EXP-00056: ORACLE error 3106 encountered ORA-03106: fatal two-task communication protocol error

The oerr utility doesn't provide much insight: ora92 >oerr ora 3106
03106, 00000, "fatal two-task communication protocol error" // *Cause:
// *Action:

I need this to run on 10g (source) database. Because 9i (production) cannot connect to 10g. It is a production system so they have it locked down.

-- 
Jimmy Brock



.



--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 26 2016 - 21:25:49 CET