Import with different Oracle version

Posted on 2009-04-29
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/ 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
    LVL 73

    Expert Comment

    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


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

    LVL 73

    Accepted Solution

    yes, exactly!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now