-
Nov09
EXP-00003的解决方法
Posted in Database, 558 views
-
当使用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:

Leave a comment | Trackback 这篇文章还没有评论.