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.
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!