ORA-00942: Table or view does not have a low-level error example, ora-00942 example
ORA-00942: a low-level error does not exist in a table or view
Run the query statement and report a ORA-00942 Error
After checking, the user who does not specify the table is found. Add the user and query again. The query is normal, as shown below:
**************************************** *******Statement************************************************
Original works, from "Deep Blue blog" blog, welcome to reprint, reprint please be sure to indicate the source (http://blog.csdn.net/huangyanlong ).
Please leave a message if the statement is incorrect. Thank you very much.
*****************************************************************************************************
Ora-00942 table or view does not exist
Config. getWebStores: java. SQL. SQLException: ORA-00942: The table or view does not exist
Try rebuilding a table or view ..
The table or view does not exist.
This error is not a big problem. It may be because you have not built it. It is a little patient. I have to check it for remote operations. I don't know what's going on, so I can't draw a conclusion easily. This is my QQ number 648957953. If you have any questions, please ask me .. Good luck
Read table data in database, error: ORA-00942: Table or view does not exist
The above is very clear, but the question is not clear. What operations do you encounter?
1. This error is obvious, that is, the table does not exist. But you have created a table and it does not exist. It may only be a user or permission issue.
2. Specifically, data_space and yong are both correct, and the authorized connection is also true. However, after you authorize the connection, you should first return to the current user, and then log in with your yong user to create the table sys_user under the yong user without specifying the tablespace data_space, because your yong user has been associated with the tablespace, all tables under the yong user are in this space by default.
3. If you have not created the sys_user table under the yong user, you have actually created this table under the user you used to log on. When you access the sys_user table under the yong user, it does not exist. If you have created a table under the yong user, you must use the user name to access the table as long as you are not operating on the table under the yong user, specifically yong. sys_user. To put it bluntly, it is a problem. The table user is not the same as the user you are currently using.