I have a table that a user tried to add a column. During the execution, he lost connection with database.
Now we can do a select but when we try to drop the table or do an update we receive the following error message.
Erro de SQL: ORA-00942: table or view does not exist
I already did a shutdown / startup on database but the problem continues.
someone have a clue?
Im using dba user, so , its not a grant related problem.
the update is:
set columnx = 123
where columny = 1111
i tried with uppercase and lowercase...
the problem is not the syntax or if tabke exists or some kind of schema name, i've made another table using select * into tableb and worked, and the same statement for udate worked too.
the table exist, i can see in dictionary, i can see the data but i cant do any DDL.
the problem is... this table have locked for DDL for some reason and now i cant update or drop or delete, but select is working...
im thinking in a kind o bug, becaouse the v$locked_objects dont show anything so, the table is not locked for any transaction.