Everyone a great god, and the normal use of the software today suddenly when saving data error ora - 00942: a table or view does not exist, with PL/SQL Developer to connect to the database to find the corresponding table, found the table can be queried, but cannot insert to update the delete, will be submitted to the 00942 error, online to find a pile of data, most consider permission problems, with grant awarded rights, but can only be granted to specific users, many users are using this form, tried a few users, but still won't do,
Online and search out table are locked, with the database administrator user login, found in the select * from v $locked_object to find locked_object this table, but with the sysdba after landing is locked - object table can be found, but the query this table without the data,

With ordinary database users and sysdba after landing the table and the view is different, sysdba permissions is high, but not the table below, that how to find the problem?

Basic can determine is this table there is a problem, not a program problem, what method or command can check this list what are the problems? Can repair the watch?

Database, I am not a very good advice from where to start to check and solve, be obliged,

CodePudding user response:

Say there is no this table, there is definitely no, can from the following several aspects of screening,

1, query the current use of table, want to consider the question of authority,
2, the software use account, whether to have PLSQL login account,
3, the table name whether to use lowercase letters,

CodePudding user response:

reference 1st floor wmxcn2000 response:

say that there is no this table, it must be not, can from the following several aspects of screening,

1, query the current use of table, want to consider the question of authority,
2, the software use account, whether to have PLSQL login account,
3, whether the table name with a lowercase letter,

Thank you,

Don't understand is if there is no this table, the software can query to the data of this form or PLSQL, just can't update,
1. How to check, check another user under the user table? While another user under the table and is the same, another user can also normal operation
2. This is not the same, I reconfirm the
3. The software has been normal use, the table name will suddenly becomes small wrote, table name can change at any time?

CodePudding user response:

Table name, won't change, unless someone (or program) initiative to modify the name of the table,

CodePudding user response:

I also met, don't know how to deal with, can query, but cannot be modified or deleted, or at 00942 errors, this form until now still lay in the database

CodePudding user response:

reference 4 floor Wazy_CSDN response:

I also met, still don't know how to deal with, can query, but shall not modify, or delete, otherwise the error, at 00942 to the present this list are still in the database with

This table is ruined? How to solve, the newly built form?

CodePudding user response:

reference 5 floor lohascsdn reply:

Quote: refer to 4th floor Wazy_CSDN response:

I also met, don't know how to deal with, can query, but shall not modify, or delete, otherwise the error, at 00942 to the present this table in database with

This table is ruined? How to solve, the newly built form?

is my personal computer practice database, not company, don't tube him anyway

CodePudding user response:

Consider the following:
1. This form is which users create? With the normal users can update the data?
2. If you can update, so is the lack of other user permissions, authorized
3. If can not update, then may be damaged (very rare, may be a hard disk failure), the need to back up your data, to build table and restore data

CodePudding user response:

Users have the right

CodePudding user response:

This is the oracle data dictionary, you must have a dba user permissions to check

CodePudding user response:

See your tip is not permission problems, is the table does not exist, with dba in to see if I can find the first list, and write operation, if found to write operation, empower ordinary user permissions to write operation, try again,

CodePudding user response:

The table name try add double quotation marks

CodePudding user response:

Probably do not have permission to update, it is recommended that check for user permissions