ORA-00942 table or view does not existCause: 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
在jbuilder中用dbswing的控件,也能看到表的内容,
但无法对表进行操作,就会出现如上的0942错误
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
不过还是谢谢各位
仍然是运行到类似语句
myStatement.executeUpdate就出现错误
但调用executeUpdate方法,更新是还是出错0942