Java开发网 - Re:Oracle常见错误代码的分析与解决

Java开发网

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate » Oracle

打印话题 寄给朋友 订阅主题

作者

Re:Oracle常见错误代码的分析与解决 [Re:九佰]

九佰

版主

发贴: 983
积分: 126

于 2003-08-01 12:35

ORA-00942:table or view does not exist

产生原因：这是由于装载的表或视图不存在，多半是CATEXP.SQL还没有运行，无法执行Export视图,如果CATEXP.SQL已经运行，则可能是版本错误。

　　解决方法：因为Import和Export共享的一些视图是通过运行CATEXP.SQL来装载的（它们具有相同的视图），并不生成单独的CATEXP.SQL，因而造成视图与Export代码不同步，较难保持彼此之间的兼容，用户就必须建立自己的Export应用，从而避免ORA-00942的错误。

　　相应的英文如下：

Cause:The table or view entered does not exist,a synonym that is jnot 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 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 priviledes are required to access the table.

Also, if attempting to access a table or view in another schema,make certain thecorrect schema is referenced and that access to the object is granted.

http://www.teamlet.org

海纳百川，有容乃大
壁立千仞，无欲则刚
智者不惑，勇者无惧
止戈为武，仁者无敌

话题树型展开

人气	标题	作者	字数	发贴时间
24138	Oracle常见错误代码的分析与解决	九佰	1057	2003-08-01 12:30
18682	Re:Oracle常见错误代码的分析与解决	九佰	1230	2003-08-01 12:32
18542	Re:Oracle常见错误代码的分析与解决	九佰	1591	2003-08-01 12:33
18444	Re:Oracle常见错误代码的分析与解决	九佰	1085	2003-08-01 12:33
18673	Re:Oracle常见错误代码的分析与解决	九佰	2042	2003-08-01 12:34
18844	Re:Oracle常见错误代码的分析与解决	九佰	1214	2003-08-01 12:35

已读帖子

新的帖子

被删除的帖子