Summary of Oracle 9 Export to Oracle 10 GB

Recently, I encountered a problem. After Oracle 10 Gb Database Export, the import in 9I was actually problematic, so

After trying to install 9I and connect to 10 Gb, use the 9I EXP command to export the data. Who knows whether the exported data is still incorrect and the BLOB fields are lost,

The following error occurs:

EXP-00003: segment not found

So I finally found the method.

1. Upgrade the client to 9.2.0.5 or above.
I used exp of 9208/10. 1.0.4 to export a table containing BLOB and CLOB. All data can be exported!

2. alternative solution:
Connect to the SYS user before export and run the following SQL:

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

After the export is complete, restore the view (the definition can be seen through user_views). The definition of Oracle9i and Oracle10g is the same:

Create or replace view exu9tne (
Tsno, fileno, blockno, length)
SELECT ts #, segfile #, segblock #, length
FROM sys. uet $
WHERE ext # = 1