Database Administration (MOSC)

MOSC Banner

ORA-00903: invalid table name

edited Sep 14, 2016 9:24AM in Database Administration (MOSC) 2 commentsAnswered ✓

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!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center