EXP-00003: storage definition solution for segment (11,419) not found

When I back up an oracle table
When you export a table with a clob type field: EXP-00003: A storage definition of segment (11,419) not found
Others can be exported normally. Key tables are not exported.

 
Problem description: When the remote server connects to another database server and wants to export data remotely, there are several tables with the error exp_00003, which are key tables. Later, I realized that it was necessary to export data on the database's local machine. Therefore, the export was successful only when the desktop was remotely connected to the database machine. It is emphasized that the large field tables must be exported to the local database.
(Down)
The local Oracle client version is 9.2.0.1, and the database server version is 9.2.0.5.
The solution is as follows:

Method 1: Upgrade the client to 9.2.0.5.

Method 2:

Step 1 modify the $ ORACLE_HOME/rdbms/admin/catexp. SQL file (make sure to back up the file before modification to prevent mistakes ),

Add "Union all select * From SYS. exu9tneb" to the last row defined by exu9tne in the view, as shown below:

Create or replace view exu9tne (
Tsno, fileno, blockno, length)
Select ts #, segfile #, segblock #, Length
From SYS. uet $
Where ext # = 1
Union all
Select * From SYS. exu9tneb
/

Step 2 run the script with the sys account.

In this way, you can use a client of a lower version to export data on a database server of version 9.2.0.5.

In comparison, the second method is recommended, because you do not need to upgrade each client to reduce the trouble. However, when using the second method, you must back up catexp. SQL.
The above method comes from the Network ()