Re: Export data from 10g into 9i
- From: "Beckstrom Jeffrey" <JBECKSTROM@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, <jimmybrock@xxxxxxxxx>
- Date: Tue, 26 Jan 2016 15:25:49 -0500
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@xxxxxxxxx> 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
.
Other related posts:
