【故障解決】ORA-06502錯誤解決
【故障解決】ORA-06502: PL/SQL: numeric or value error: character string buffer too small
一.1 BLOG文件結構圖
一.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 故障環境介紹
專案 | source db |
db 型別 | rac |
db version | 10.2.0.5 |
db 儲存 | FS type |
ORACLE_SID | xxx |
db_name | xxx |
主機IP地址: | XXX.XXX.XXX.XXX |
OS版本及kernel版本 | AIX 6 |
OS hostname | ZTGXPADDB1 |
一.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
Copyright (c) 2003, 2007, Oracle. All rights reserved.
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
Copyright (c) 2003, 2007, Oracle. All rights reserved.
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';
SELECT *
FROM DBA_SEQUENCES D
WHERE D.sequence_name IN
('AQ$_KUPC$DATAPUMP_QUETAB_N', 'AQ$_KUPC$DATAPUMP_QUETAB_1_N');
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
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
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
----------
1
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
Copyright (c) 2003, 2007, Oracle. All rights reserved.
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
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
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
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
Copyright (c) 2003, 2007, Oracle. All rights reserved.
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
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
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
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
Copyright (c) 2003, 2007, Oracle. All rights reserved.
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$
oracle@ZTGXPADDB1:/softtmp$
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
Copyright (c) 2003, 2007, Oracle. All rights reserved.
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
...........................................................................................................................................................................................
本文作者:小麥苗,只專注於資料庫的技術,更注重技術的運用
ITPUB BLOG:http://blog.itpub.net/26736162
本文地址:http://blog.itpub.net/26736162/viewspace-1982193/
本文pdf版:http://yunpan.cn/cdEQedhCs2kFz (提取碼:ed9b)
QQ:642808185 若加QQ請註明您所正在讀的文章標題
於 2016-01-25 10:00~ 2016-01-25 19:00 在中行完成
<版權所有,文章允許轉載,但須以連結方式註明源地址,否則追究法律責任!>
...........................................................................................................................................................................................
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26736162/viewspace-1982193/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Ocelot錯誤解決
- 解決 Python UnicodeEncodeError 錯誤PythonUnicodeError
- PbootCMS 404 錯誤解決方法boot
- Linux下錯誤解決方案Linux
- latex 錯誤以及解決方案
- 解決MySQL server has gone away錯誤的解決方案MySqlServerGo
- dbfread報錯ValueError錯誤解決方法Error
- steam磁碟寫入錯誤怎麼解決 steam磁碟寫入錯誤解決方法大全
- undefined reference to錯誤的解決方法Undefined
- Cocopods的升級錯誤解決
- ORA-12005 錯誤的解決
- SAXParseException的錯誤解決之二Exception
- ORA-28000錯誤解決方案
- dedecms提示500錯誤解決方法
- PHP curl error 60 錯誤解決PHPError
- linux解決“XXX is not in the sudoers file”錯誤Linux
- 解決java.lang.NoSuchMethodError錯誤JavaError
- HTTP代理錯誤怎麼解決?HTTP
- HTTP 錯誤 500.19- Internal Server Error 錯誤解決方法HTTPServerError
- Go:錯誤 could not launch process: EOF 解決Go
- 畢設之錯誤解決辦法
- 解決 ngrok 的 Domain 錯誤問題AI
- 錯誤解決:Attempting to use uninitialized value VariableZed
- Ubuntu Cannot allocate memory 錯誤解決方案Ubuntu
- Qt報Multiple definition錯誤的解決QT
- Excel匯入null錯誤解決方式ExcelNull
- 代理508限制錯誤怎麼解決?
- Hadoop常見錯誤及解決方案Hadoop
- Idea編譯錯誤解決辦法Idea編譯
- windows故障轉移叢集 “群集事件” 經常出現 1135 錯誤的解決Windows事件
- 錯誤720寬頻連線解決辦法 寬頻連線錯誤程式碼720怎麼解決
- ORA-10873 故障解決
- 解決ubuntu系統“XXX is not in the sudoers file”錯誤Ubuntu
- ubuntu下import matplotlib錯誤解決辦法UbuntuImport
- HTTP 錯誤 500.21 - Internal Server Error 解決方案HTTPServerError
- SyntaxError: EOL while scanning string literal錯誤解決ErrorWhile
- 解決 eslint 的 Parsing error: Unexpected token 錯誤EsLintError
- Mac上搭建chromedriver的錯誤解決方法MacChrome
- 解決shell指令碼錯誤$’r’ command not found指令碼