############################ Error symptom: ###############################
The following error occurs when exporting data with 9i exp:
F: \ Oracle \ bin> exp wssw/foresee @ cradle203 file = d: \ sb_sbxx_zb.dmp tables = sb_sbxx_zb
Export: Release 9.2.0.1.0-Production on Friday May 27 11:15:24 2011
Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.
Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options
The ZHS16GBK and AL16UTF16 NCHAR character sets have been exported.
To export the specified table, use the regular path...
... Exporting table SB_SBXX_ZB...
EXP-00003: storage definitions for segments (6,) not found
The export is successfully terminated, but a warning is displayed.
######################################## #################################
View metalink and find that this error will occur as long as the exp before 9.2.0.5 is used to export tables with LOB fields in the database after 9.2.0.5.
Solution:
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
You can import data normally during 9i import without any errors.