What is Oracle's 942 error?

Oracle's 942 error indicates that the table or view does not exist; the reason for this error is that the exp version is different from the database version. Although the installation package has been installed successfully, the relevant information in the table has not been updated. You can view it with "select comp_id,version from dba_registry".

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

What is Oracle's 942 error?

ORA-00942: The table or view does not exist;

The reason for this error is: due to exp The version is different from the database version.

Although the installation package has been installed successfully, the relevant information in the data dictionary table has not been updated.

View through this statement

connected.

SQL> shutdow immediate

The database has been closed.

The database has been unloaded.

ORACLE routine has been closed.

SQL> startup migrate

ORACLE routine has been started.

Total System Global Area 1687760036 bytes
Fixed Size                   457892 bytes
Variable Size             486539264 bytes
Database Buffers         1199570944 bytes
Redo Buffers                1191936 bytes

The database is loaded.

Network management network bitsCN.com

The database has been opened.

SQL> spool d:\catpatch.log
SQL> @d:\oracle\ora92\rdbms\admin\catpatch.sql
SQL> spool off

Note: catexp will be called in catpatch to modify exp

So far, exp has been modified successfully

Using exp to export successfully DD

After patching,

SQL>shutdown immediate
SQL>startup 正常打开，
942 oracle Oracle

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of What is Oracle's 942 error?. For more information, please follow other related articles on the PHP Chinese website!