Import with different Oracle version

Posted on 2009-04-29
Medium Priority
Last Modified: 2013-12-19
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/manager@devd.cts.com 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.
Question by:sachin_dba
  • 2
LVL 74

Expert Comment

ID: 24259254
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


Author Comment

ID: 24259698

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

LVL 74

Accepted Solution

sdstuber earned 1500 total points
ID: 24260394
yes, exactly!

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question