当使用9205以前版本的exp程序去9205及以上的数据库中去导出带LOB字段的表时, 会遇到一个错误, 错误信息为"EXP-00003 : 没找到段的存贮定义 .....", 事实上这是一个Oracle的Bug, 可以通过监时地更改视图"exu9tne"的定义来临时解决问题, 如下所示:

    在导出前, 连接到SYS用户, 运行以下SQL:

CREATE OR REPLACE VIEW exu9tne (
tsno, fileno, blockno, length) AS
SELECT ts#, segfile#, segblock#, length
FROM sys.uet$
WHERE ext# = 1
UNION ALL
SELECT * FROM SYS.EXU9TNEB
/

    导出完成后, 运行以下命令来还原视图的定义, 下面贴的是Oracle 9用的, 10g的还是请访问Metalink来确定, 或者在运行前一个命令之前, 从USER_VIEWS中将原视图的定义查出来, 这样做也是DBA一个很好的习惯.

CREATE OR REPLACE VIEW exu9tne (
tsno, fileno, blockno, length) AS
SELECT ts#, segfile#, segblock#, length
FROM sys.uet$
WHERE ext# = 1
/

*********以上来自anySQL.net***************

---

附：metalink文档

Subject:	Getting EXP-00003 Errors While Exporting a Transport Set to Create the .dmp File
	Doc ID:	Note:316215.1	Type:	PROBLEM
	Last Revision Date:	11-JUL-2005	Status:	MODERATED

Applies to:

Portal - Version: 9.0.2 to 9.0.4
This problem can occur on any platform.
 

Symptoms

You are using Portal Export/Import utilities under the following scenario:

• Your Portal is installed in a custom database version 9.2.0.5 or higher.
• You are running the export script from your transport set from the MIDTIER_HOME.
• The export log file generated by the export from the command line shows the following error:

EXP-00003: no storage definition found for segment(%lu, %lu)

Note: The export log file is created in the same directory where you run the export script.

Cause

The error is caused by the following database bug:

Bug 3784697 EXPORT OF LOB FROM 9205 WITH PRE-9205 EXP GIVES EXP-3 (NO STORAGE DEF FOUND)

Solution

Workaround 1

Run the export script from the DATABASE_HOME.

Workaround 2

Apply the Workaround from the following note to run the export script from the MIDTIER_HOME:

Note 274076.1 EXP-00003 When Exporting From 9.2.0.5.0 or 10.1.0.2.0 with a Pre-9.2.0.5.0 Export Utility

References

Bug 3784697 - Export Of Lob From 9205 With Pre-9205 Exp Gives Exp-3 (No Storage Def Found)
Note 274076.1 - EXP-00003 When Exporting From 9.2.0.5.0 or any Higher Release with a Pre-9.2.0.5.0 Export Client
 

Errors

EXP-3 "no storage definition found for segment(%lu, %lu)"
 

Related posts:

1. windows平台上的LRM-00116
2. 在RHAS4下安装ORACLE9I遇到的2个问题
3. Solaris系统启动过程