1. Upgrade the client to 9.2.0.5 or above. I used the exp of 920810.1.0.4 to export a table containing BLOB and CLOB. All data can be exported! 2. alternative solution: Export
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: Export
There are two methods:
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
,