主页 / dba / 问题 / 859
Accepted
LudoMC
Asked: 2011-01-26 00:58:50 +0800 CST

执行完整备份时出现 EXP-00085 警告

  • 772

在完全导出 Oracle 10.2.0.2 数据库期间，我遇到以下警告

[...]
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 6502 encountered
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 351
ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 14
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling     SYS.DBMS_SCHED_JOB_EXPORT.create_exp for object 102269
EXP-00008: ORACLE error 6502 encountered
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 351
ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 14
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_SCHED_JOB_EXPORT.create_exp for object 102271
EXP-00008: ORACLE error 6502 encountered
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 351
ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 14
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_SCHED_JOB_EXPORT.create_exp for object 102273
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully with warnings.

我查找了这三个使用它们的 object_id 查询 dba_objects 的对象，它返回

  • ADV_SQLACCESS5150248
  • ADV_SQLACCESS9067727
  • ADV_SQLACCESS2676493

这些警告令人担忧吗？

我应该如何修复它们以及到底发生了什么？

oracle export

2 个回答

  1. Best Answer

    我预计这是 10.2.0.4 中修复的错误 5120780（在 Metalink 上快速搜索会告诉你）。

    • 4

  2. 盖乌斯是正确的。+1 万一其他人将来遇到此问题，已知它会在任何平台上的 10.1.0.2 到 10.2.0.3 上发生。除了升级到 10.2.0.4 之外，还可以应用补丁 5120780 来解决此问题。该补丁可用于有限的平台集。

    • 2

相关问题