EXP error EXP-00003 EXP-00091 EXP-00015

今天在用9.2.0.1客户端exp导出9.2.0.7的schema的时候，在log中发现有以下错误，

在网上查了一下，刚好有人也碰到过这个问题，应该是oracle的一个小bug.

EXP-00003: no storage definition found for segment(13, 3945)

Cause:

The error is caused by a database bug as explained in the following note:

Note 3291851.8 Bug 3291851 - EXP-3 exporting LOB from 9205 or higher DB with <9205 export >

Table being exported is in Oracle9i 9.2.0.5.0 or any higher source database.

Table itself or Large Object (LOB) in table has more than one extent allocated.

The version of the Export utility is Pre-9.2.0.5.0.

Export can be either table level or schema level or database level.

解决的方法可以参照后文的Reference.

[@more@]

为了避开这个问题，我直接在服务器上去exp了，但是又碰到以下问题

EXP-00091: Exporting questionable statistics

这个问题是字符集引起，查看HP-UX的系统的NLS_LANG

$ echo $NLS_LANG

american_america.UTF8

查看当前数据库的字符集

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')

----------------------------------------------------

AMERICAN_AMERICA.AL32UTF8

设置HP-UX的NLS_LANG

$ export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

然后EXP-00091问题解决，但是又出现以下问题

vxfs: msgcnt 19680 mesg 001: V-2-1: vx_nospace - /dev/vg00/lvol5 file system full (1 block extent)

EXP-00015: error on row 497704 of table PN_PIVOT, column X, datatype 2

EXP-00002: error in writing to export file

EXP-00002: error in writing to export fileerror closing export file pnet.dmp

EXP-00000: Export terminated unsuccessfully

从第一行来看，应该是改分区下磁盘已满，

$ pwd

/home/oracle/pnet

$ df -k

/home (/dev/vg00/lvol5 ) : 131072 total allocated Kb

0 free allocated Kb

131072 used allocated Kb

100 % allocation used

果然，是磁盘问题，改到其他分区目录下，所有问题解决，导出成功！

Reference:

【EXP-00003】

http://space.itpub.net/9252210/viewspace-566589

http://www.eygle.com/archives/2009/02/oracle_exp_00003.html

【EXP-00091】

http://space.itpub.net/519536/viewspace-591158

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12472709/viewspace-1035265/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12472709/viewspace-1035265/