【故障解决】ORA-06502错误解决

ゝ一纸荒年。 2022-02-05 05:39 886阅读 0赞

**【故障解决】ORA-06502: PL/SQL: numeric or value error: character string buffer too small**

## 一.1 BLOG文档结构图 ##

[![wpsFD2F.tmp\[4\]][wpsFD2F.tmp_4]][wpsFD2F.tmp_4_wpsFD2F.tmp_4]

## 一.2 前言部分 ##

### 一.2.1 导读和注意事项 ###

各位技术爱好者，看完本文后，你可以掌握如下的技能，也可以学到一些其它你所不知道的知识，~O(∩\_∩)O~：

① EXPDP和IMPDP基于scn的导出

② ora-06502的解决方法

**Tips：**

① 若文章代码格式有错乱，推荐使用QQ或360浏览器，也可以下载pdf格式的文档来查看，pdf文档下载地址：http://yunpan.cn/cdEQedhCs2kFz  （提取码：ed9b）

② 本篇BLOG中代码部分需要特别关注的地方我都用\*\*\*背景和红色字体来表示，比如下边的例子中，thread 1的最大归档日志号为33，thread 2的最大归档日志号为43是需要特别关注的地方，命令一般使用粉红颜色标注，注释一般采用蓝色字体表示。

List of Archived Logs in backup set 11

Thrd Seq Low SCN Low Time Next SCN Next Time

\---- ------- ---------- ------------------- ---------- ---------

1 32 1621589 2015-05-29 11:09:52 1625242 2015-05-29 11:15:48

1 33 1625242 2015-05-29 11:15:48 1625293 2015-05-29 11:15:58

2 42 1613951 2015-05-29 10:41:18 1625245 2015-05-29 11:15:49

2 43 1625245 2015-05-29 11:15:49 1625253 2015-05-29 11:15:53

\[ZFXDESKDB1:root\]:/>lsvg -o

T\_XDESK\_APP1\_vg

rootvg

\[ZFXDESKDB1:root\]:/>

\[ZFXDESKDB1:root\]:/>lsvg rootvg

====》2097152\*512/1024/1024/1024=1G

**本文如有错误或不完善的地方请大家多多指正，ITPUB留言或QQ皆可，您的批评指正是我写作的最大动力。**

### 一.2.2 相关参考文章链接 ###

http://blog.itpub.net/29324876/viewspace-1248197/

http://blog.itpub.net/26736162/viewspace-1982160/

### 一.2.3 本文简介 ###

执行导出操作的时候报错信息如下：

ORA-31626: job does not exist

ORA-31638: cannot attach to job SYS\_EXPORT\_SCHEMA\_01 for user XXXXX

ORA-06512: at "SYS.DBMS\_SYS\_ERROR", line 95

ORA-06512: at "SYS.KUPV$FT\_INT", line 389

ORA-39077: unable to subscribe agent KUPC$A\_2\_20210102154238 to queue "KUPC$C\_2\_20210102154237"

ORA-06512: at "SYS.DBMS\_SYS\_ERROR", line 95

ORA-06512: at "SYS.KUPC$QUE\_INT", line 249

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

网上查询后有网友已经遇到了，连接地址：http://blog.itpub.net/26736162/viewspace-1982160/ ，我直接根据这个来解决吧。

## 一.3 相关知识点扫盲 ##

## 一.4 故障分析及解决过程 ##

### 一.4.1 故障环境介绍 ###

<table style="font-family:'Helvetica Neue', Helvetica, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', '微软雅黑', Arial, sans-serif;font-size:16px;border-collapse:collapse;color:rgb(51,51,51);text-align:justify;"> 
 <tbody> 
 <tr> 
 <td style="border:.5pt solid;"> &nbsp;项目 </td> 
 <td style="border-width:.5pt .5pt .5pt medium;border-style:solid solid solid none;"> source db </td> 
 </tr> 
 <tr> 
 <td style="border-width:medium .5pt .5pt;border-style:none solid solid;"> db&nbsp;类型 </td> 
 <td style="border-width:medium .5pt .5pt medium;border-style:none solid solid none;"> rac </td> 
 </tr> 
 <tr> 
 <td style="border-width:medium .5pt .5pt;border-style:none solid solid;"> db version </td> 
 <td style="border-width:medium .5pt .5pt medium;border-style:none solid solid none;"> 10.2.0.5 </td> 
 </tr> 
 <tr> 
 <td style="border-width:medium .5pt .5pt;border-style:none solid solid;"> db&nbsp;存储 </td> 
 <td style="border-width:medium .5pt .5pt medium;border-style:none solid solid none;"> FS type </td> 
 </tr> 
 <tr> 
 <td style="border-width:medium .5pt .5pt;border-style:none solid solid;"> ORACLE_SID </td> 
 <td style="border-width:medium .5pt .5pt medium;border-style:none solid solid none;"> xxx </td> 
 </tr> 
 <tr> 
 <td style="border-width:medium .5pt .5pt;border-style:none solid solid;"> db_name </td> 
 <td style="border-width:medium .5pt .5pt medium;border-style:none solid solid none;"> xxx </td> 
 </tr> 
 <tr> 
 <td style="border-width:medium .5pt .5pt;border-style:none solid solid;"> 主机IP地址： </td> 
 <td style="border-width:medium .5pt .5pt medium;border-style:none solid solid none;"> XXX.XXX.XXX.XXX </td> 
 </tr> 
 <tr> 
 <td style="border-width:medium .5pt .5pt;border-style:none solid solid;"> OS版本及kernel版本 </td> 
 <td style="border-width:medium .5pt .5pt medium;border-style:none solid solid none;"> AIX 6 </td> 
 </tr> 
 <tr> 
 <td style="border-width:medium .5pt .5pt;border-style:none solid solid;"> OS hostname </td> 
 <td style="border-width:medium .5pt .5pt medium;border-style:none solid solid none;"> ZTGXPADDB1 </td> 
 </tr> 
 </tbody> 
</table>

### 一.4.2 故障发生现象及报错信息 ###

oracle@ZTGXPADDB1:/gg/ogg/dirrpt$ expdp XXXXX/XXXXX@22.188.131.27:1521/oraXPAD DIRECTORY=DATA\_PUMP\_DIR DUMPFILE=XXXXX\_20160125.dmp LOGFILE=XXXXX\_20160125.log FLASHBACK\_SCN=12242466617347

Export: Release 10.2.0.5.0 - 64bit Production on Saturday, 02 January, 2021 15:42:47

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

ORA-31626: job does not exist

ORA-31638: cannot attach to job SYS\_EXPORT\_SCHEMA\_01 for user XXXXX

ORA-06512: at "SYS.DBMS\_SYS\_ERROR", line 95

ORA-06512: at "SYS.KUPV$FT\_INT", line 389

ORA-39077: unable to subscribe agent KUPC$A\_2\_20210102154238 to queue "KUPC$C\_2\_20210102154237"

ORA-06512: at "SYS.DBMS\_SYS\_ERROR", line 95

ORA-06512: at "SYS.KUPC$QUE\_INT", line 249

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

### 一.4.3 故障分析过程 ###

oracle@ZTGXPADDB1:/gg/ogg/dirrpt$ expdp XXXXX/XXXXX@22.188.131.27:1521/oraXPAD DIRECTORY=DATA\_PUMP\_DIR DUMPFILE=XXXXX\_20160125.dmp LOGFILE=XXXXX\_20160125.log FLASHBACK\_SCN=12242466617347

Export: Release 10.2.0.5.0 - 64bit Production on Saturday, 02 January, 2021 15:42:47

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

ORA-31626: job does not exist

ORA-31638: cannot attach to job SYS\_EXPORT\_SCHEMA\_01 for user XXXXX

ORA-06512: at "SYS.DBMS\_SYS\_ERROR", line 95

ORA-06512: at "SYS.KUPV$FT\_INT", line 389

ORA-39077: unable to subscribe agent KUPC$A\_2\_20210102154238 to queue "KUPC$C\_2\_20210102154237"

ORA-06512: at "SYS.DBMS\_SYS\_ERROR", line 95

ORA-06512: at "SYS.KUPC$QUE\_INT", line 249

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

根据资料解决过程如下：

SELECT**\***

FROM dba\_objects d

WHERE d.OBJECT\_NAME like'%DATAPUMP%'

AND D.OBJECT\_TYPE **=**'SEQUENCE'**;**

[![wpsFD40.tmp\[4\]][wpsFD40.tmp_4]][wpsFD40.tmp_4_wpsFD40.tmp_4]

SELECT**\***

FROM DBA\_SEQUENCES D

WHERE D.sequence\_name IN

**(**'AQ$\_KUPC$DATAPUMP\_QUETAB\_N'**,**'AQ$\_KUPC$DATAPUMP\_QUETAB\_1\_N'**);**

[![wpsFD41.tmp\[4\]][wpsFD41.tmp_4]][wpsFD41.tmp_4_wpsFD41.tmp_4]

oracle@ZTGXPADDB1:/gg/ogg/dirrpt$ sqlplus / as sysdba

SQL\*Plus: Release 10.2.0.5.0 - Production on Sat Jan 2 16:08:47 2021

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

SQL> SELECT AQ$\_KUPC$DATAPUMP\_QUETAB\_N.CURRVAL FROM DUAL;

SELECT AQ$\_KUPC$DATAPUMP\_QUETAB\_N.CURRVAL FROM DUAL

ERROR at line 1:

ORA-08002: sequence AQ$\_KUPC$DATAPUMP\_QUETAB\_N.CURRVAL is not yet defined in

this session

SQL> SELECT AQ$\_KUPC$DATAPUMP\_QUETAB\_N.NEXTVAL FROM DUAL;

NEXTVAL

\----------

1194988

SQL> DROP SEQUENCE AQ$\_KUPC$DATAPUMP\_QUETAB\_1\_N;

DROP SEQUENCE AQ$\_KUPC$DATAPUMP\_QUETAB\_1\_N

ERROR at line 1:

ORA-02289: sequence does not exist

SQL> DROP SEQUENCE AQ$\_KUPC$DATAPUMP\_QUETAB\_N;

Sequence dropped.

SQL> CREATE SEQUENCE AQ$\_KUPC$DATAPUMP\_QUETAB\_N MINVALUE 1 MAXVALUE 999999 START WITH 1 INCREMENT BY 1 CACHE 20 CYCLE;

Sequence created.

SQL> SELECT AQ$\_KUPC$DATAPUMP\_QUETAB\_N.NEXTVAL FROM DUAL;

NEXTVAL

\----------

SQL> EXIT

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

oracle@ZTGXPADDB1:/gg/ogg/dirrpt$

oracle@ZTGXPADDB1:/gg/ogg/dirrpt$ expdp XXXXX/XXXXX DIRECTORY=DATA\_PUMP\_DIR DUMPFILE=XXXXX\_20160125.dmp LOGFILE=XXXXX\_20160125.log FLASHBACK\_SCN=12242466617347

Export: Release 10.2.0.5.0 - 64bit Production on Saturday, 02 January, 2021 16:11:46

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

ORA-39002: invalid operation

ORA-39070: Unable to open the log file.

ORA-39087: directory name DATA\_PUMP\_DIR is invalid

[![wpsFD61.tmp\[4\]][wpsFD61.tmp_4]][wpsFD61.tmp_4_wpsFD61.tmp_4]

oracle@ZTGXPADDB1:/gg/ogg/dirrpt$ cd /oracle/app/oracle/product/10.2.0/db/rdbms/log/

oracle@ZTGXPADDB1:/oracle/app/oracle/product/10.2.0/db/rdbms$ sqlplus / as sysdba

SQL\*Plus: Release 10.2.0.5.0 - Production on Sat Jan 2 16:17:56 2021

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

SQL> grant read,write on directory DATA\_PUMP\_DIR to XXXXX;

Grant succeeded.

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

oracle@ZTGXPADDB1:/oracle/app/oracle/product/10.2.0/db/rdbms$ expdp XXXXX/XXXXX DIRECTORY=DATA\_PUMP\_DIR DUMPFILE=XXXXX\_20160125.dmp LOGFILE=XXXXX\_20160125.log FLASHBACK\_SCN=12242466617347

Export: Release 10.2.0.5.0 - 64bit Production on Saturday, 02 January, 2021 16:18:06

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

FLASHBACK automatically enabled to preserve database integrity.

Starting "XXXXX"."SYS\_EXPORT\_SCHEMA\_01": XXXXX/\*\*\*\*\*\*\*\* DIRECTORY=DATA\_PUMP\_DIR DUMPFILE=XXXXX\_20160125.dmp LOGFILE=XXXXX\_20160125.log FLASHBACK\_SCN=12242466617347

Estimate in progress using BLOCKS method...

Processing object type SCHEMA\_EXPORT/TABLE/TABLE\_DATA

Total estimation using BLOCKS method: 11.15 GB

Processing object type SCHEMA\_EXPORT/PRE\_SCHEMA/PROCACT\_SCHEMA

Processing object type SCHEMA\_EXPORT/SYNONYM/SYNONYM

Processing object type SCHEMA\_EXPORT/DB\_LINK

Processing object type SCHEMA\_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA\_EXPORT/TABLE/TABLE

Processing object type SCHEMA\_EXPORT/TABLE/TABLE\_DATA

Total estimation using BLOCKS method: 11.15 GB

Processing object type SCHEMA\_EXPORT/PRE\_SCHEMA/PROCACT\_SCHEMA

Processing object type SCHEMA\_EXPORT/SYNONYM/SYNONYM

Processing object type SCHEMA\_EXPORT/DB\_LINK

Processing object type SCHEMA\_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA\_EXPORT/TABLE/TABLE

Processing object type SCHEMA\_EXPORT/TABLE/GRANT/OWNER\_GRANT/OBJECT\_GRANT

Processing object type SCHEMA\_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA\_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA\_EXPORT/TABLE/INDEX/STATISTICS/INDEX\_STATISTICS

Processing object type SCHEMA\_EXPORT/TABLE/COMMENT

Processing object type SCHEMA\_EXPORT/PACKAGE/PACKAGE\_SPEC

Processing object type SCHEMA\_EXPORT/FUNCTION/FUNCTION

Processing object type SCHEMA\_EXPORT/PROCEDURE/PROCEDURE

Processing object type SCHEMA\_EXPORT/PACKAGE/COMPILE\_PACKAGE/PACKAGE\_SPEC/ALTER\_PACKAGE\_SPEC

Processing object type SCHEMA\_EXPORT/FUNCTION/ALTER\_FUNCTION

Processing object type SCHEMA\_EXPORT/PROCEDURE/ALTER\_PROCEDURE

Processing object type SCHEMA\_EXPORT/VIEW/VIEW

Processing object type SCHEMA\_EXPORT/VIEW/GRANT/OWNER\_GRANT/OBJECT\_GRANT

Processing object type SCHEMA\_EXPORT/PACKAGE/PACKAGE\_BODY

Processing object type SCHEMA\_EXPORT/TABLE/CONSTRAINT/REF\_CONSTRAINT

Processing object type SCHEMA\_EXPORT/TABLE/TRIGGER

Processing object type SCHEMA\_EXPORT/TABLE/INDEX/FUNCTIONAL\_AND\_BITMAP/INDEX

Processing object type SCHEMA\_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL\_AND\_BITMAP/INDEX\_STATISTICS

Processing object type SCHEMA\_EXPORT/TABLE/STATISTICS/TABLE\_STATISTICS

. . exported "XXXXX"."RICH\_CUSTPRODUCTBAL" 63.64 KB 582 rows

. . exported "XXXXX"."FINANCIAL\_SALEBANK" 2.311 GB 28137697 rows

. . exported "XXXXX"."XPADC\_LCCPZTB" 2.866 MB 32160 rows

. . exported "XXXXX"."RICH\_CUSTOMERINFO" 616.9 KB 2596 rows

. . exported "XXXXX"."RICH\_CUSTACCOUNT" 11.33 MB 177757 rows

. . exported "XXXXX"."FINANCIAL\_MESSAGEINFO" 329.7 MB 3067896 rows

. . exported "XXXXX"."RICH\_AUTOTRADE" 36.53 KB 161 rows

. . exported "XXXXX"."BASE\_SYSLOG" 24.70 KB 131 rows

. . exported "XXXXX"."CORP\_FINANCIAL\_MESSAGEINFO" 7.820 KB 3 rows

. . exported "XXXXX"."FINANCIAL\_POSITIONHIS" 20.93 MB 413414 rows

. . exported "XXXXX"."BASE\_TRANCOURSE" 23.38 KB 157 rows

**《《《《篇幅原因，有省略。。。。。。。。。。。。。。。）》》》**

UDE-00008: operation generated ORACLE error 31626

ORA-31626: job does not exist

ORA-39086: cannot retrieve job information

ORA-06512: at "SYS.DBMS\_DATAPUMP", line 2772

ORA-06512: at "SYS.DBMS\_DATAPUMP", line 3886

ORA-06512: at line 1

oracle@ZTGXPADDB1:/oracle/app/oracle/product/10.2.0/db/rdbms$ df -g

Filesystem GB blocks Free %Used Iused %Iused Mounted on

/dev/hd4 2.00 1.82 9% 6857 2% /

/dev/hd2 10.00 6.01 40% 69921 5% /usr

/dev/hd9var 2.00 1.19 41% 3613 2% /var

/dev/hd3 2.00 1.75 13% 2572 1% /tmp

/dev/hd1 6.00 6.00 1% 9 1% /home

/proc - - - - - /proc

/dev/hd10opt 2.00 1.69 16% 7156 2% /opt

/dev/Tlv\_oracle 30.00 4.66 85% 645205 37% /oracle

/dev/Tlv\_softtmp 80.00 79.56 1% 12 1% /softtmp

/dev/itm\_lv 3.00 1.91 37% 5101 2% /opt/IBM/ITM

/dev/Tlv\_xpad 95.00 35.89 63% 1118 1% /xpad

ZTINIMSERVER:/sharebin 100.00 2.12 98% 1219019 69% /sharebin

22.188.129.240:/sharebin 100.00 2.12 98% 1219019 69% /sharebin

22.188.129.240:/sharebkup 5500.00 1890.76 66% 2455955 1% /sharebkup

/dev/fslv00 300.00 284.07 6% 21 1% /ggbak

/dev/Tlv\_gg 218.50 43.95 80% 4772 3% /gg

[![wpsFD72.tmp\[4\]][wpsFD72.tmp_4]][wpsFD72.tmp_4_wpsFD72.tmp_4]

oracle@ZTGXPADDB1:/softtmp$ expdp XXXXX/XXXXX DIRECTORY=DMP DUMPFILE=XXXXX\_20160125.dmp LOGFILE=XXXXX\_20160125.log FLASHBACK\_SCN=12242466617347

oracle@ZTGXPADDB1:/softtmp$ sqlplus / as sysdba

SQL\*Plus: Release 10.2.0.5.0 - Production on Sat Jan 2 16:38:32 2021

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

SQL> Select current\_scn from v$database;

CURRENT\_SCN

\-----------

1.2242E+13

SQL> col current\_scn format 999999999999999

SQL> Select current\_scn from v$database;

CURRENT\_SCN

\----------------

12242466771468

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

oracle@ZTGXPADDB1:/softtmp$ expdp XXXXX/XXXXX DIRECTORY=DMP DUMPFILE=XXXXX\_20160125.dmp LOGFILE=XXXXX\_20160125.log FLASHBACK\_SCN=12242466771468

Export: Release 10.2.0.5.0 - 64bit Production on Saturday, 02 January, 2021 16:39:06

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

FLASHBACK automatically enabled to preserve database integrity.

Starting "XXXXX"."SYS\_EXPORT\_SCHEMA\_01": XXXXX/\*\*\*\*\*\*\*\* DIRECTORY=DMP DUMPFILE=XXXXX\_20160125.dmp LOGFILE=XXXXX\_20160125.log FLASHBACK\_SCN=12242466771468

Estimate in progress using BLOCKS method...

Processing object type SCHEMA\_EXPORT/TABLE/TABLE\_DATA

Total estimation using BLOCKS method: 11.15 GB

Processing object type SCHEMA\_EXPORT/PRE\_SCHEMA/PROCACT\_SCHEMA

Processing object type SCHEMA\_EXPORT/SYNONYM/SYNONYM

Processing object type SCHEMA\_EXPORT/DB\_LINK

Processing object type SCHEMA\_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA\_EXPORT/TABLE/TABLE

Processing object type SCHEMA\_EXPORT/TABLE/GRANT/OWNER\_GRANT/OBJECT\_GRANT

Processing object type SCHEMA\_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA\_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA\_EXPORT/TABLE/INDEX/STATISTICS/INDEX\_STATISTICS

Processing object type SCHEMA\_EXPORT/TABLE/COMMENT

Export> status

Job: SYS\_EXPORT\_SCHEMA\_01

Operation: EXPORT

Mode: SCHEMA

State: EXECUTING

Bytes Processed: 0

Current Parallelism: 1

Job Error Count: 0

Dump File: /softtmp/dmp/XXXXX\_20160125.dmp

bytes written: 4,096

Worker 1 Status:

State: EXECUTING

Object Schema: XXXXX

Object Name: XPAD\_SH

Object Type: SCHEMA\_EXPORT/PACKAGE/PACKAGE\_SPEC

Completed Objects: 1

Total Objects: 1

Worker Parallelism: 1

Export> kill\_job

Are you sure you wish to stop this job (\[yes\]/no): yes

oracle@ZTGXPADDB1:/softtmp$

[![wpsFD73.tmp\[4\]][wpsFD73.tmp_4]][wpsFD73.tmp_4_wpsFD73.tmp_4]

[![wpsFD83.tmp\[4\]][wpsFD83.tmp_4]][wpsFD83.tmp_4_wpsFD83.tmp_4]

oracle@ZTGXPADDB1:/softtmp$

oracle@ZTGXPADDB1:/softtmp$ expdp XXXXX/XXXXX directory=DMP dumpfile=XXXXX\_20160125\_01.dmp LOGFILE=XXXXX\_20160125.log TABLES=BASE\_ACTIONPOWER,BASE\_BANK,BASE\_BANKMERGE,BASE\_BANKTREE,BASE\_BRCHBANKCTRL,BASE\_CERTIFICATE,BASE\_CESS,BASE\_COREBANK,BASE\_CURRENCY,BASE\_DEPARTMENT,BASE\_HOLIDAYCALENDAR,BASE\_HOLIDAYDATE,BASE\_INTEREST,BASE\_INTERESTHIS,BASE\_MAINAREA,BASE\_MENU,BASE\_PRODTYPECODE,BASE\_RATE,BASE\_ROLE,BASE\_SYSLOG,BASE\_SYSPARAM,BASE\_TERMINALTELLER,BASE\_USER,FINANCIAL\_BANKPROFITLOG,FINANCIAL\_DIVIDENDPLAN,FINANCIAL\_FUNDPRICE,FINANCIAL\_INTERESTRESET,FINANCIAL\_ISSUE,FINANCIAL\_ISSUEAUDIT,FINANCIAL\_ISSUEAUDITHIS,FINANCIAL\_ISSUEBRAND,FINANCIAL\_ISSUECFL,FINANCIAL\_ISSUECONTROL,FINANCIAL\_ISSUEDIFFRATE,FINANCIAL\_ISSUEDISCOUNT,FINANCIAL\_ISSUEEXPD,FINANCIAL\_ISSUEEXT,FINANCIAL\_ISSUEFEE,FINANCIAL\_ISSUEFORCUSTRISKLVL,FINANCIAL\_ISSUEFUNDSTRANSFER,FINANCIAL\_ISSUEOBSERV,FINANCIAL\_ISSUEPAY,FINANCIAL\_ISSUEPROFIT,FINANCIAL\_ISSUEQTYSPLIT,FINANCIAL\_ISSUESELLCTRL,FINANCIAL\_ISSUESERIAL,FINANCIAL\_ISSUEVARIABLE,FINANCIAL\_ISSUEWORKTIME,FINANCIAL\_LIQUIDATEACT,FINANCIAL\_MESSAGEINFO,FINANCIAL\_PERIOD,FINANCIAL\_PRICE,FINANCIAL\_PRICEHIS,FINANCIAL\_REFERINDEX,FINANCIAL\_POSITION,RICH\_AUTOTRADE,RICH\_CUSTACCOUNT,RICH\_CUSTAUTOTRADE,RICH\_CUSTAUTOTRADEHIS,RICH\_CUSTCAPITAL,RICH\_CUSTFAVORABLE,RICH\_CUSTFREEZEUNIT,RICH\_CUSTFUNDPROFIT,RICH\_CUSTIMPAWN,RICH\_CUSTKEEPBAL,RICH\_CUSTOMERINFO,RICH\_CUSTOMERINFOHIS,RICH\_CUSTORDERTRADE,RICH\_CUSTPAYAMOUNTLOG,RICH\_CUSTPRODUCTBAL,RICH\_CUSTPRODUCTBALQTY,RICH\_CUSTPROFITDCCY,RICH\_CUSTPROFITLOG,RICH\_CUSTPROFITNORMAL,RICH\_CUSTPROFITPAYMODE,RICH\_CUSTPROFITPAYMODEHIS,RICH\_CUSTRISKLVL,RICH\_FUNDTRADELOG,RICH\_NOPAYAMOUNT,RICH\_NORMALPAY,RICH\_ORDERTRADE,RICH\_SMSCMDSIGN,RICH\_SMSCMDTRADE,RICH\_STARTBAL,RICH\_STARTBALHIS,financial\_positionhis,financial\_positiontra,financial\_positioncst,financial\_positionacc,corp\_stattemptab,corp\_stattemptabacc,corp\_stattemptabcst,FINANCIAL\_ICCARDCODE,BASE\_FINANCIALICCARD,FINANCIAL\_ISSUESPECIFICATION,PA\_RPT\_PARAM,FINANCIAL\_SALEBANK\_HIS,RICH\_TRADELOG\_HIS,RICH\_CUSTPAYAMOUNTHIS\_HIS,RICH\_CUSTPRODUCTBALHIS\_HIS,RIC

Export: Release 10.2.0.5.0 - 64bit Production on Saturday, 02 January, 2021 16:41:50

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

Starting "XXXXX"."SYS\_EXPORT\_TABLE\_01": XXXXX/\*\*\*\*\*\*\*\* directory=DMP dumpfile=XXXXX\_20160125\_01.dmp LOGFILE=XXXXX\_20160125.log TABLES=BASE\_ACTIONPOWER,BASE\_BANK,BASE\_BANKMERGE,BASE\_BANKTREE,BASE\_BRCHBANKCTRL,BASE\_CERTIFICATE,BASE\_CESS,BASE\_COREBANK,BASE\_CURRENCY,BASE\_DEPARTMENT,BASE\_HOLIDAYCALENDAR,BASE\_HOLIDAYDATE,BASE\_INTEREST,BASE\_INTERESTHIS,BASE\_MAINAREA,BASE\_MENU,BASE\_PRODTYPECODE,BASE\_RATE,BASE\_ROLE,BASE\_SYSLOG,BASE\_SYSPARAM,BASE\_TERMINALTELLER,BASE\_USER,FINANCIAL\_BANKPROFITLOG,FINANCIAL\_DIVIDENDPLAN,FINANCIAL\_FUNDPRICE,FINANCIAL\_INTERESTRESET,FINANCIAL\_ISSUE,FINANCIAL\_ISSUEAUDIT,FINANCIAL\_ISSUEAUDITHIS,FINANCIAL\_ISSUEBRAND,FINANCIAL\_ISSUECFL,FINANCIAL\_ISSUECONTROL,FINANCIAL\_ISSUEDIFFRATE,FINANCIAL\_ISSUEDISCOUNT,FINANCIAL\_ISSUEEXPD,FINANCIAL\_ISSUEEXT,FINANCIAL\_ISSUEFEE,FINANCIAL\_ISSUEFORCUSTRISKLVL,FINANCIAL\_ISSUEFUNDSTRANSFER,FINANCIAL\_ISSUEOBSERV,FINANCIAL\_ISSUEPAY,FINANCIAL\_ISSUEPROFIT,FINANCIAL\_ISSUEQTYSPLIT,FINANCIAL\_ISSUESELLCTRL,FINANCIAL\_ISSUESERIAL,FINANCIAL\_ISSUEVARIABLE,FINANCIAL\_ISSUEWORKTIME,FINANCIAL\_LIQUIDATEACT,FINANCIAL\_MESSAGEINFO,FINANCIAL\_PERIOD,FINANCIAL\_PRICE,FINANCIAL\_PRICEHIS,FINANCIAL\_REFERINDEX,FINANCIAL\_POSITION,RICH\_AUTOTRADE,RICH\_CUSTACCOUNT,RICH\_CUSTAUTOTRADE,RICH\_CUSTAUTOTRADEHIS,RICH\_CUSTCAPITAL,RICH\_CUSTFAVORABLE,RICH\_CUSTFREEZEUNIT,RICH\_CUSTFUNDPROFIT,RICH\_CUSTIMPAWN,RICH\_CUSTKEEPBAL,RICH\_CUSTOMERINFO,RICH\_CUSTOMERINFOHIS,RICH\_CUSTORDERTRADE,RICH\_CUSTPAYAMOUNTLOG,RICH\_CUSTPRODUCTBAL,RICH\_CUSTPRODUCTBALQTY,RICH\_CUSTPROFITDCCY,RICH\_CUSTPROFITLOG,RICH\_CUSTPROFITNORMAL,RICH\_CUSTPROFITPAYMODE,RICH\_CUSTPROFITPAYMODEHIS,RICH\_CUSTRISKLVL,RICH\_FUNDTRADELOG,RICH\_NOPAYAMOUNT,RICH\_NORMALPAY,RICH\_ORDERTRADE,RICH\_SMSCMDSIGN,RICH\_SMSCMDTRADE,RICH\_STARTBAL,RICH\_STARTBALHIS,financial\_positionhis,financial\_positiontra,financial\_positioncst,financial\_positionacc,corp\_stattemptab,corp\_stattemptabacc,corp\_stattemptabcst,FINANCIAL\_ICCARDCODE,BASE\_FINANCIALICCARD,FINANCIAL\_ISSUESPECIFICATION,PA\_RPT\_PARAM,FINANCIAL\_SALEBANK\_HIS,RICH\_TRA

Estimate in progress using BLOCKS method...

Processing object type TABLE\_EXPORT/TABLE/TABLE\_DATA

Total estimation using BLOCKS method: 6.913 GB

Processing object type TABLE\_EXPORT/TABLE/TABLE

Processing object type TABLE\_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE\_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE\_EXPORT/TABLE/INDEX/STATISTICS/INDEX\_STATISTICS

Processing object type TABLE\_EXPORT/TABLE/COMMENT

Processing object type TABLE\_EXPORT/TABLE/TRIGGER

Processing object type TABLE\_EXPORT/TABLE/INDEX/FUNCTIONAL\_AND\_BITMAP/INDEX

Processing object type TABLE\_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL\_AND\_BITMAP/INDEX\_STATISTICS

Processing object type TABLE\_EXPORT/TABLE/STATISTICS/TABLE\_STATISTICS

. . exported "XXXXX"."RICH\_CUSTPRODUCTBAL" 63.64 KB 582 rows

. . exported "XXXXX"."RICH\_CUSTOMERINFO" 616.9 KB 2596 rows

. . exported "XXXXX"."RICH\_CUSTACCOUNT" 11.33 MB 177757 rows

. . exported "XXXXX"."FINANCIAL\_MESSAGEINFO" 329.7 MB 3067896 rows

**《《《《篇幅原因，有省略。。。。。。。。。。。。。。。）》》》**

. . exported "XXXXX"."RICH\_TRADELOG\_HIS":"P\_201411" 0 KB 0 rows

. . exported "XXXXX"."RICH\_TRADELOG\_HIS":"P\_201412" 0 KB 0 rows

. . exported "XXXXX"."RICH\_TRADELOG\_HIS":"P\_999999" 0 KB 0 rows

ORA-39166: Object RIC was not found.

Master table "XXXXX"."SYS\_EXPORT\_TABLE\_01" successfully loaded/unloaded

\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

Dump file set for XXXXX.SYS\_EXPORT\_TABLE\_01 is:

/softtmp/dmp/XXXXX\_20160125\_01.dmp

Job "XXXXX"."SYS\_EXPORT\_TABLE\_01" completed with 1 error(s) at 16:42:37

## 一.5 故障处理总结 ##

删除sys下的DATAPUMP序列号，因为该序列号不能超过6位，后续版本已经fixed的了。

SQL> DROP SEQUENCE AQ$\_KUPC$DATAPUMP\_QUETAB\_N;

Sequence dropped.

SQL> CREATE SEQUENCE AQ$\_KUPC$DATAPUMP\_QUETAB\_N MINVALUE 1 MAXVALUE 999999 START WITH 1 INCREMENT BY 1 CACHE 20 CYCLE;

到此所有的处理算是基本完毕，过程很简单，但是不同的场景处理方式有很多种，我们应该学会灵活变通。

## 一.6 About Me ##

本文转自lhrbest 51CTO博客，原文链接：http://blog.51cto.com/lhrbest/1738443，如需转载请自行联系原作者

[wpsFD2F.tmp_4]: http://s3.51cto.com/wyfs02/M01/7A/43/wKiom1amI9bAgySSAABg4TD_64M818.jpg
[wpsFD2F.tmp_4_wpsFD2F.tmp_4]: /images/20220205/49cbe61892bb403faaf5bf4863c1f513.png
[wpsFD40.tmp_4]: http://s3.51cto.com/wyfs02/M02/7A/44/wKiom1amI9fC2Rd8AACRj8V42zs966.jpg
[wpsFD40.tmp_4_wpsFD40.tmp_4]: /images/20220205/0f17f6b4359046b0afb792a50a342ca7.png
[wpsFD41.tmp_4]: http://s3.51cto.com/wyfs02/M02/7A/43/wKioL1amJByAJmXPAACBrtzvpKY222.jpg
[wpsFD41.tmp_4_wpsFD41.tmp_4]: /images/20220205/4a88a9c5d0504712bb742f4e4600ae34.png
[wpsFD61.tmp_4]: http://s3.51cto.com/wyfs02/M00/7A/44/wKiom1amI93yfDb4AAI_lp61OA0012.jpg
[wpsFD61.tmp_4_wpsFD61.tmp_4]: /images/20220205/956c08a989654be598be11d366b0a824.png
[wpsFD72.tmp_4]: http://s3.51cto.com/wyfs02/M01/7A/44/wKiom1amI-HgebPJAAJK45HGoC4141.jpg
[wpsFD72.tmp_4_wpsFD72.tmp_4]: /images/20220205/eadc9e7f68e44f53975e2e6245ede7c3.png
[wpsFD73.tmp_4]: http://s3.51cto.com/wyfs02/M02/7A/44/wKiom1amI-Gw8bWuAABSNDxVZEM179.jpg
[wpsFD73.tmp_4_wpsFD73.tmp_4]: /images/20220205/116f3b1c93614c6eb0920e1d45323e7e.png
[wpsFD83.tmp_4]: http://s3.51cto.com/wyfs02/M02/7A/44/wKiom1amI-OwmwjxAAD6bLW0oTU480.jpg
[wpsFD83.tmp_4_wpsFD83.tmp_4]: /images/20220205/4efdc3d9dd4848ce879716bd8d5f3172.png