ITPub博客

首页 > 数据库 > Oracle > Full Database Export Fails with EXP-00008

Full Database Export Fails with EXP-00008

原创 Oracle 作者:liuxh6 时间:2019-05-14 13:00:07 0 删除 编辑
  • fact: Oracle Server - Enterprise Edition 8
  • fact: Export Utility (EXP)
  • symptom: Full Database Export Fails
  • symptom: EXP-00008: ORACLE error %lu encountered
  • symptom: ORA-01403: no data found
  • symptom: ORA-06512: at %s, line%s
  • symptom: EXP-00085: The previous problem occurred when calling %s.%s.%s for
    object %
  • cause: CATNOQUE appears to be intended for upgrades from 803 only, although
    the documentation implies it can be used to clean up AQ - it cannot be used to
    clean up AQ.
  • [@more@]fix:

    Make sure you have a valid backup.

    Run the following statements as SYS.
    SQL> delete from sys.exppkgact$
    where package = 'DBMS_AQ_EXP_QUEUE_TABLES'
    or package = 'DBMS_AQ_EXP_INDEX_TABLES'
    or package = 'DBMS_AQ_EXP_TIMEMGR_TABLES'
    or package = 'DBMS_AQ_EXP_HISTORY_TABLES'
    or package = 'DBMS_AQ_EXP_SUBSCRIBER_TABLES';

    SQL> delete from sys.exppkgobj$ where package = 'DBMS_AQ_EXP_QUEUES';
    SQL> commit;

    Rerun the export

    Reference:
    Bug:1662274 OUTSTANDING IMPORT/EXPORT ERRORS

    .

    来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7104/viewspace-1010279/,如需转载,请注明出处,否则将追究法律责任。

    下一篇: 纪念外婆
    请登录后发表评论 登录
    全部评论

    注册时间:2002-02-24

    • 博文量
      87
    • 访问量
      60101