Restore the database that backs up Oracle 10 Gb in Oracle 9i

If you want to restore a database on a colleague's machine to your own machine, the DMP file provided by the colleague cannot be used. I suddenly thought of Oracle 10 Gb, and I was still in the Oracle 9I stage. Back up again with your own 9I client, resulting in a EXP-00003 error. I checked on the Internet that the BLOB field is used in the table (it seems that this field does not affect Data Storage). By the way, I found a solution. After using this field, the record is as follows:

1. log on to Oracle 10 Gb as a SYS user and run the following SQL statement to update the view:

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. EXP operation on the machine with Oracle 9I installed

3. IMP operation on the machine with Oracle 9I installed

4. Remember to change the view back to Oracle 10 Gb.

Create or replace view exu9tne (

Tsno, fileno, blockno, length)

SELECT ts #, segfile #, segblock #, length

FROM sys. uet $

WHERE ext # = 1