Import with different Oracle version

Source Dump file version :
Destination database version : Oracle9i Release

We can not use for importing dump.

So I am using Oracle 10g client.

But getting following errors.

D:\OraHome_1\bin>imp system/ fromuser=NOVASTAGE TOUSER=NOVAS
TAGE FILE=D:\Imp_Dev\novastage_130309.dmp LOG=D:\Imp_Dev\novastage_IMP.log GRANT

Import: Release - 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.
Who is Participating?
sdstuberConnect With a Mentor Commented:
yes, exactly!
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

sachin_dbaAuthor Commented:

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

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.