Export data from 10g into 9i
Date: Tue, 26 Jan 2016 12:16:40 -0800
Message-ID: <CA+AQkuz=uVWM_wooDscS+ooX8AFKxTvkjh5qZuUDR--AsDjCzQ_at_mail.gmail.com>
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-lReceived on Tue Jan 26 2016 - 21:16:40 CET