免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 5443 | 回复: 1
打印 上一主题 下一主题

exp 时报错EXP-00008,ORA-00904,该如何解决? [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2004-06-29 16:08 |只看该作者 |倒序浏览
我想将公司的数据通过EXP导出来备份,前段时间都是好的,可这次出问题了,我查看了错误信息,可它没有讲解决的方法,我该怎么做?
psb1>; exp

Export: Release 8.1.5.0.0 - Production on Mon Jun 28 09:15:43 2004

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


Username: qygl/qygl@mis

Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
Enter array fetch buffer size: 4096 >; 8192

Export file: expdat.dmp >; 200406qygl.dmp  

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U >;

Export grants (yes/no): yes >;

Export table data (yes/no): yes >;

Compress extents (yes/no): yes >;

Export done in ZHS16CGB231280 character set and ZHS16CGB231280 NCHAR character set

About to export specified users ...
User to be exported: (RETURN to quit) >; qygl

User to be exported: (RETURN to quit) >;  

. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCGL
. exporting object type definitions for user QYGL
About to export QYGL's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessf
psb>;

论坛徽章:
0
2 [报告]
发表于 2009-06-26 13:10 |只看该作者
执行\rdbms\admin\catexp.sql应该就可以了
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP