?
Solved

Import with different Oracle version

Posted on 2009-04-29
3
Medium Priority
?
1,928 Views
Last Modified: 2013-12-19
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.
0
Comment
Question by:sachin_dba
  • 2
3 Comments
 
LVL 74

Expert Comment

by:sdstuber
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






0
 

Author Comment

by:sachin_dba
ID: 24259698
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
 
LVL 74

Accepted Solution

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

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