Data Tables cannot be inserted or updated in Oracle databases.

In the Oracle database, the data table cannot execute the update statement because the data table is locked by another user. The solution is as follows:

First, execute the following SQL statement:

Select * from v $ session t1, v $ locked_object t2 where t1.sid = t2.SESSION _ ID;

Or

Select sess. sid, sess. serial #, lo. oracle_username, lo. OS _user_name, ao. object_name, lo. locked_mode from v $ locked_object lo, dba_objects ao, v $ session sess where ao. object_id = lo. object_id and lo. session_id = sess. sid;

Then, find different users in the query results, and execute the following statement to kill unnecessary users.

Alter system kill session 'sid, seria # ', where sid and seria # are redundant users

Finally, execute the SQL statement first. If no query result exists, the solution is completed.