ORACLE常见错误代码的分析与解决

核心提示： ORA-00942:table or view does not exist产生原因：这是由于装载的表或视图不存在，多半是CATEXP.SQL还没有运行，ORACLE常见错误代码的分析与解决(7)，无法执行Export视图,如果CATEXP.SQL已经运行，则可能是版本错误，较难保持彼此之

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.

ORA-01598:rollback segment “name” is not online