网络编程 | 站长之家 | 网页制作 | 图形图象 | 操作系统 | 冲浪宝典 | 软件教学 | 网络办公 | 邮件系统 | 网络安全 | 认证考试 | 系统进程
Firefox | IE | Maxthon | 迅雷 | 电驴 | BitComet | FlashGet | QQ | QQ空间 | Vista | 输入法 | Ghost | Word | Excel | wps | Powerpoint
asp | .net | php | jsp | Sql | c# | Ajax | xml | Dreamweaver | FrontPages | Javascript | css | photoshop | fireworks | Flash | Cad | Discuz!
当前位置 > 网站建设学院 > 网络编程 > 数据库 > Oracle教程
Tag:注入,存储过程,分页,安全,优化,xmlhttp,fso,jmail,application,session,防盗链,stream,无组件,组件,md5,乱码,缓存,加密,验证码,算法,cookies,ubb,正则表达式,水印,索引,日志,压缩,base64,url重写,上传,控件,Web.config,JDBC,函数,内存,PDF,迁移,结构,破解,编译,配置,进程,分词,IIS,Apache,Tomcat,phpmyadmin,Gzip,触发器,socket
数据库:数据库教程,数据库技巧,Oracle教程,MySQL教程,Sybase教程,Access教程,DB2教程,数据库安全,数据库文摘
本月文章推荐
.整合Oracle 10g、Apache 2.0、Ph.
.跨越应用经理与DBA之间的鸿沟.
.Oracle常见错误代码的分析与解决.
.Oracle大批量删除数据方法.
.ORACLE入门之监控数据库性能的SQL.
.在DB2中如何實現Oracle的相關功能.
.教会你掌握oracle外表.
.Linux环境下 用XMMS听MP3.
.合理设置数据库以提高查询统计速.
.如何学习Oracle?.
.Linux_FAQ之六:疑难杂症.
.oracle系统紧急故障处理.
.ORACLE数据库记录输出到文本文件.
.Oracle巧取指定记录与巧用外关联.
.Oracle导出程序Exp的使用具体过程.
.Oracle10g废弃log_archive_start.
.Solaris 下的 oracle 的基本操作.
.Oracle9i 对象关系技术.
.杜绝安全隐患 容易忽视Oracle安全.
.Oracle性能调优过程中如何观察缓.

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

发表日期:2008-2-9


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 942 encountered ORA-00942: table or view does not exist EXP-00024: Export views not installed, please notify your DBA EXP-00000: Export terminated unsUCcessfully   查帮助:   ORA-00942 table or view does not exist   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.   Action: Check each of the following:   the spelling of the table or view name. that a view is not specified where a table is required. that an existing table or view name exists. Contact the database administrator if the table needs to be created or if user or application privileges are required to access the table.   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.   发现这个帮助对解决问题的帮助不太,后来想起有人说过,用高版本的EXP导出低版本会有这个问题,偶的是从9.2.0.1升级到9.2.0.4,可以有可能某些EXP需要的字典没有被升级,只要用9.2.0.1的客户端去导出啦。

上一篇:9i新特性之——在线表格重定义研究1 人气:547
下一篇:关于block中行数据的存储与空间重组二 人气:519
浏览全部Oracle教程的内容 Dreamweaver插件下载 网页广告代码 祝你圣诞节快乐 2009年新年快乐