This content has been marked as final. Show 6 replies
i already did...
i just hide the schema name and the table name
the select is:
select * from schema.table
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.
you are not providing the information necessary to find out where is the 'bug'.
Show the result of the query below:
select owner, table_name from dba_tables where table_name='&table';
I don't want you to gimme examples(like you did twice above), i want the real name of owner, and real name of table.
I want the real query that you used, not an example.
If you can't give me this information, i can't know where is the error. Help me to help you.