发表文章 返回首页

在EXP出数据时遇到ORA-00942的问题的解决办法

时间:2005-12-17 08:00来源:中国网管联盟 作者:BitsCN整理 点击:
exporting pre-schema procedural objects and actions . exporting foreign function library names for user ITEM . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user ITEM EXP-00008: ORACLE error
  

exporting pre-schema procedural objects and actions 中国网管联盟www、bitsCN、com

. exporting foreign function library names for user ITEM

中国网管联盟www.bitscn.com

. exporting PUBLIC type synonyms 网管网bitsCN_com

. exporting private type synonyms 中国网管联盟www.bitscn.com

. exporting object type definitions for user ITEM feedom.net

EXP-00008: ORACLE error 942 encountered

网管网bitsCN.com

ORA-00942: table or view does not exist

54com.cn

EXP-00024: Export views not installed, please notify your DBA 54ne.com

EXP-00000: Export terminated unsuccessfully

中国网管联盟www、bitsCN、com

 

中国网管联盟www_bitscn_com

查帮助: 网管联盟www.bitsCN.com

  54ne.com

ORA-00942 table or view does not exist 中国网管联盟www_bitscn_com

  54com.cn

Cause: The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.

网管网bitsCN_com

 

中国网管论坛bbs.bitsCN.com

Action: Check each of the following: 中国网管联盟www、bitsCN、com

  网管联盟www.bitsCN.com

the spelling of the table or view name. 中国网管论坛bbs.bitsCN.com

that a view is not specified where a table is required. 中国网管联盟www.bitscn.com

that an existing table or view name exists.

网管网bitsCN_com

Contact the database administrator if the table needs to be created or if user or application privileges are required to access the table. 中国网管联盟www、bitsCN、com

  feedom.net

Also, if attempting to access a table or view in another schema, make certain the correct schema is referenced and that access to the object is granted. 网管网bitsCN.com

 

feedom.net

发现这个帮助对解决问题的帮助不太,后来想起有人说过,用高版本的EXP导出低版本会有这个问题,偶的是从9.2.0.1升级到9.2.0.4,可以有可能某些EXP需要的字典没有被升级,只要用9.2.0.1的客户端去导出啦。
中国网管联盟www_bitscn_com

顶一下
(0)
0%
踩一下
(0)
0%
------分隔线----------------------------
最新评论 查看所有评论
发表评论 查看所有评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
评价:
表情:
用户名: 密码: 验证码:
发布者资料
admin 查看详细资料 发送留言 加为好友 用户等级:注册会员 注册时间:2008-05-08 23:05 最后登录:2009-01-05 00:01
推荐内容