:

IMP-00058 – Using Oracle 10G client with 9i Database

IMP-00058 Import Terminated Unsuccessfully

UPDATE: Although these IMP-00058 errors were encountered when using a 10g and 9i client, I believe that it can also apply to other versions of Oracle where there is a mismatch between the client utilities when exporting and importing

IMP-00058: ORACLE error 6550 encountered
ORA-06550: line 1, column 33:
PLS-00302: component ‘SET_NO_OUTLINES’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
IMP-00000: Import terminated unsuccessfully

This error was encountered when exporting from a 9i database using a 10g client, and then importing into a 9i databse using the 10g client. I had to export and import using the 9i client in the end.

Setting the Correct Path

If you are using Windows, type PATH at the command prompt and see what the values are set to. There will most likely be multiple Oracle paths in there. For example, D:\Oracle\Ora92 and D:\Oracle\product\10.2.0\db_1, for a 9i client and a 10g one. The one which appears first will take priority over the others.

You can modify which appears first on your command prompt session by copying out the path to a text file, re-arranging it so that either the 9i or 10g one appears first and then copying it back into your command prompt window, with a PATH=D:\Oracle\Ora92…..etc, etc.

Making it Permanent

You can also modify this parameter for the environment permanently, with the following:

  • Click START -> right click My Computer -> Properties -> Advanced System Settings -> Environment Variables
  • In the “System Variables” box at the bottom there is a PATH variable
  • Click “Edit” and then change the order for which Oracle Home appears first in the list

The main image of this post should help you see where you go to when changing the Windows PATH environment variable.

Being Explicit

If you are still unsure, you can also specify the full path whenever you invoke SQLPlus or IMP/EXP, etc. For example, my PATH variable has has D:\Oracle\Ora92 at the beginning of it but I want to use the 10g Export executable, so I would type:

D:\Oracle\Product\10.2.0\db_1\BIN\EXP to invoke the export command

If you would like to read more about database monitoring, have a look at my other articles on TEMP space monitoring and UNDO space monitoring. These really are topics that every Oracle DBA should know well and have monitoring in place to avoid the issues.

Like it, share it...

Category: Export/Import


Related Posts

Comments (7)

Trackback URL | Comments RSS Feed

  1. chand basha says:

    Sir ,i hav one problem.i m using obiee 11g version is 11.1.1.7.0 .the obi installed everythng is done.i was getting importing problm…i completd supplier2 connect in cmd prompt…but it’s not imported.then wat hapnd there.i cnt undrstnd wat hapnd there.pls tel me great solution.i got lot of tym waste.enter prise model also opened.everythng is done.but it was nt imported.pls tel me

  2. Miles says:

    Thank you boss. It works

Leave a Reply

Your email address will not be published. Required fields are marked *