In this particular case, I was trying to export from a 10.2.0.4 db with exp from 8.1.7.4.
The schema in question had (several) lobsegments, which would trigger Oracle bug 3784697.
Summary Bug report:
Bug 3784697: EXPORT OF LOB FROM 9205 WITH PRE-9205 EXP GIVES EXP-3 (NO STORAGE DEF FOUND)
________________________________________
Bug Attributes
________________________________________
Type B – Defect Fixed in Product Version –
Severity 2 – Severe Loss of Service Product Version 9.2.0.4
Status 96 – Closed, Duplicate Bug Platform 100 – z*OBSOLETE: Microsoft Windows 2000
Created 22-Jul-2004 Platform Version 5
Updated 29-Jul-2004 Base Bug 3291851
Database Version 9.2.0.5
Affects Platforms Generic
Product Source Oracle
Related Products
________________________________________
Line Oracle Database Products Family Oracle Database
Area Oracle Database Product 5 – Oracle Server – Enterprise Edition
Hdr: 3784697 9.2.0.5 RDBMS 9.2.0.4 EXPORT PRODID-5 PORTID-100 EXP-3 3291851
Abstract: EXPORT OF LOB FROM 9205 WITH PRE-9205 EXP GIVES EXP-3 (NO STORAGE DEF FOUND)
*** 07/22/04 02:49 am ***
TAR:
—-
PROBLEM:
——–
1. Description of problem: export with pre-9.2.0.5 from 9.2.0.5 database
fails with:
About to export specified tables via Conventional Path …
. . exporting table MY_BLOB
EXP-3: no storage definition found for segment(9, 955)
Export terminated successfully with warnings.
2. Pertinent configuration information (MTS/OPS/distributed/etc): N/A.
3. Indication of the frequency and predictability: reproducible.
4. Sequence of events leading to the problem:
– in 9.2.0.5 create table with lob segment that has more than 1 extent
– export the table with 9.2.0.4 or lower export utility
5. Technical impact on the customer. Include persistent after effects:
Many customers do not have the latest patchset installed on the Oracle9i
Release 2 database (currently 9.2.0.5). Or they have other databases in
production with a lower release, like 9.2.0.1 or 8.1.7.4.
If they need to export from an 9.2.0.5 database in order to import into
this lower release database, they need to use the lower release export
utility. This defect is preventing them to export from an 9.2.0.5 database
with any pre-9.2.0.5 release export utility.