oracle expdp导出报错“字符串缓冲区太小”
发布网友
发布时间：2022-04-26 14:40
共1个回答
热心网友
时间：2022-04-08 00:56
我把里面关于这个的文章粘给你，不给你翻译了挺长的。
你看看Symptoms应该是你这个问题，在你的11.2.0.1.0是可以发生的。
后面有Solution
Symptoms
All of a sudden, your data pump export jobs all fail with the following bunch of errors:
Export: Release 11.2.0.3.0 - Proction on Sunday, Apr 28, 22:00:26 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Proction
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-31626: Job does not exist
ORA-31638: cannot attach to job Your_JOBNAME for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 428
ORA-39077: unable to subscribe agent KUPC$A_4_220050709685000 to queue "KUPC$C_4_20130428220032"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 250
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Solution
Initially, Oracle Development built a fix under Patch 16473783.
We found out that the fix was incomplete and needed to be re-written.
This is under progress and monitored via unpublished Bug 16928674.
After encountering this symptom, this is not resolved unless recreating of datapump like followings.
@$ORACLE_HOME/rdbms/admin/catdph.sql
@$ORACLE_HOME/rdbms/admin/prvtdtde.plb
@$ORACLE_HOME/rdbms/admin/catdpb.sql
@$ORACLE_HOME/rdbms/admin/dbmspump.sql
@$ORACLE_HOME/rdbms/admin/utlrp.sql
Generally speaking, we can recreate the datapump objects in 11g by calling;
1. Catproc.sql
SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql
2. To recompile invalid objects, if any
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
This is described in Note 430221.1 How To Reload Datapump Utility EXPDP/IMPDP
