红河信息港
故事
当前位置:首页 > 故事

在EXP出数据时遇到ORA00942的问

发布时间:2019-06-20 06:35:01 编辑:笔名

  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的客户端去导出啦。

  查看本文来源

老年人腹泻原因
老年人厌食症的症状
慢性肠胃炎消化不良