Import with different Oracle version

Source Dump file version : 9.2.0.8
Destination database version : Oracle9i Release 9.0.1.1.1

We can not use 9.0.1.1.1 for importing 9.2.0.8 dump.

So I am using Oracle 10g client.10.2.0.1.0

But getting following errors.

D:\OraHome_1\bin>imp system/manager@devd.cts.com fromuser=NOVASTAGE TOUSER=NOVAS
TAGE FILE=D:\Imp_Dev\novastage_130309.dmp LOG=D:\Imp_Dev\novastage_IMP.log GRANT
S=N

Import: Release 10.2.0.1.0 - Production on Wed Apr 29 15:34:03 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


IMP-00058: ORACLE error 6550 encountered
ORA-06550: line 1, column 33:
PLS-00302: component 'SET_NLS_NUMERIC_CHAR' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
IMP-00000: Import terminated unsuccessfully

Any workaroud possible.
sachin_dbaAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
yes, exactly!
0
 
sdstuberCommented:
with import and export...

always use the LOWEST version of source and target databases for the export
always use the SAME version of the target database for the import.


So, your scenario is broken already.


If your target is  not 9.2  then your source dump file is unusable, or at best, unreliable.
You can't use 10g import into a 9i database






0
 
sachin_dbaAuthor Commented:
thanks,

if we take exp using 9.0.1.1.1 client for 9.2.0.8, can we import into 9.0.1.1.1


Sachin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.