Oracleexp appears & quot; ORA-00302: must describe the SET_NO_OUTLINES component & quot; Solution
1. Problem Description
Using the oracle exp tool, oracle 11g is installed on my client, and oracle 9i is installed on the server. The following error occurs when I want to use the exp command on the client:
Export: Release 11.2.0.3.0-Production on Wednesday March 4 09:10:53 2015 Copyright (c) 1982,201 1, Oracle and/or its affiliates. all rights reserved. EXP-00056: encounter ORACLE error 6550ORA-06550: 1st rows, 41st columns: PLS-00302: must describe 'set _ no_outlines' component ORA-06550: 1st rows, 15th columns: PL/SQL: Statement ignoredEXP-00000: export termination failed
2. Cause Analysis
There are some problems with importing and exporting Oracle versions, such as the dmp file exp from oracle 9i (using the exp command on the machine where oracle 9i is installed ), it can be imp to oracle 11g (machines with oracle 11g installed), but it does not work in turn.
In addition, you cannot directly use the exp command on the client (with oracle 11g installed) to send a request to the database on the server (oracle 9i) to export data to the client machine.
The ORA-00302 error is caused by this.
3. Solution
Export on the server and copy the exported dmp file to the client.