asked on

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.

Sean Stuber

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_dba

ASKER

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

ASKER CERTIFIED SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial