Question about how to export blob and clob fields in a later version of the database from the Oracle9i client exp

Title: question about how to export blob and clob fields in a later version of the database from the Oracle9i client exp

Body:

Use the client exp command of Oracle9i (Version: 9.2.0.1.0) to export the Oracle10g Database. If the table contains blob or clob fields, the following error is returned:

---------

EXP-00003: storage definitions for segments (13,115) not found

---------

The table cannot be exported successfully.

After searching for materials and testing, it is found that a problem may be caused by version differences.

The problem can be corrected through the following operations:

1. Modify the catexp. SQL file of the Oracle client.

The catexp. SQL file is installed on the Oracle client in the path ../ora92/rdbms/admin.

Back up the catexp. SQL file before modification.

Open the catexp. SQL file and find the view "exu9tne ".

Then, the statement "Union all select * From SYS. exu9tneb" is added to the last row defined by the view exu9tne.

The format is as follows:

---------

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

/

---------

2. Run the script with the sys account:

 

----------

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
/

Grant select on SYS. exu9tne to public;

----------

 

After the above operations, you can use the exp command on the Oracle9i client to successfully export tables containing blob or clob fields in the Oracle10g Database.

 

By jrq

2009/02/20