Recently, I encountered a problem. After exporting the Oracle10G Database, there was a problem with importing it in 9I. So I tried to install 9I, connect it to 10G, and use the EXP command of 9I to export it, who knows how to export
Recently, I encountered a problem. After exporting the Oracle 10 Gb database, there was a problem with importing it in 9I. So I tried to install 9I and connect it to 10 Gb, who knows how to export data using the 9I EXP command?
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
,