exp时遇到EXP-00008&ORA-06550&ORA-00904的解决

在使用Oracle数据库的EXP工具导出时遇到错误EXP-00008、ORA-06550和ORA-00904。问题源于ORDSYS用户被删除但exppkgact$字典表未更新。解决方案包括删除exppkgact$中不一致的记录以及重建缺失的视图EXU8GRN并授权。经过这些步骤,EXP操作能够成功完成。
摘要由CSDN通过智能技术生成
exp时遇到EXP-00008&ORA-06550&ORA-00904的解决
现象:exp时报错,如下:
[oracle@cicgo1 oracle]$ exp system/pass owner=cicgo file=/tmp/cicgo.dmp

Export: Release 8.1.7.4.0 - Production on Tue Apr 23 15:07:17 2013

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to: Oracle8i Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production
Export done in US7ASCII character set and ZHS16GBK NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'ORDSYS.ORDTEXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling ORDSYS.ORDTEXP.schema_info_exp
. exporting foreign function library names for user cicgo
. exporting object type definitions for user cicgo
About to export cicgo's objects ...
. exporting database links
. exporting sequence numbers
EXP-00008: ORACLE error 904 encountered
  • 1
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值