Oracle exp appears ORA-00302: must describe the set_no_outlines component work und

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.1 . 0.6 . 0   - Production On Friday July 15   21 : 40 : 58   2011 Copyright (c)  1982 , 2007 , Oracle. All  Rights Reserved.  Exp  -  00056 : Oracle Error 6550  Ora  -  06550 : No 1 Row, number41  Column: pls  -  00302 : Required '  Set_no_outlines  '  Component ora  -  06550 : No 1 Row, number 15  Column: PL  /  SQL: Statement ignored Exp  -  00000 : An error occurred while terminating the export.

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.