独孤狼群
===========================================================
Full Database Export Fails with EXP-00008
===========================================================
  • 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.
  •  查看全文
    liuxh6 发表于:2008.09.07 16:37 ::分类: ( oracle数据库 ) ::阅读:(169次) :: 评论 (0)
    ===========================================================
    ora-00604 ora-00942 问题处理
    ===========================================================

    数据库版本oracle10.2.0.1 ,用户无法删除

    SQL> drop user mr cascade;

    drop user mr cascade

    ORA-00604: error occurred at recursive SQL level 1
    ORA-00942: table or view does not exist

     查看全文
    liuxh6 发表于:2008.09.03 15:03 ::分类: ( oracle数据库 ) ::阅读:(279次) :: 评论 (0)
    切换风格
    新闻聚合
    博客日历
    文章归档...
    最新发表...
    博客统计...
    Blog信息
    网站链接...