首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > oracle >

ORA-00942: table or view does not exist

2014-01-28 
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With the Partitioning

Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in ZHS16GBK character set and UTF8 NCHAR character set
server uses ZHS32GB18030 character set (possible charset conversion)
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully

怎么解决呢?

------解决方法--------------------------------------------------------
高版本客户端导低版本服务器数据经常出现这个问题
运行一下数据库自带的脚本——catexp.sql,catpatch.sql
看看行不行
------解决方法--------------------------------------------------------
建议还是使用要相同版本(或低于)的客户端导出~~或者在服务器上直接EXP



------解决方法--------------------------------------------------------
http://zealot.blog.ccidnet.com/blog/ccid/do_showone/tid_45605.html

        

热点排行