ORA-00903: invalid table name
Hi, I tried to delete a record from a table and got the message ORA-00903: invalid table name
I can describe the table.
I can select from the same table.
With select, I can see the record I want to delete.
I tried deleting with owner.table-name, same result.
I can see the table records in EM, the record I want to delete is there.
I just can't delete it.
SQL> select count(*) from stable;
COUNT(*)
----------
15367
SQL> delete * from owner.stable where S_ID = 1234567;
*
ERROR at line 1:
ORA-00903: invalid table name
Any ideas?
Thanks!