今天在用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

【EXP-00091】

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

EXP error EXP-00003 EXP-00091 EXP-00015

相關文章