I really dont understand this???
I am logged in as user "PRODUCTION", I look in the schema "PRODUCTION" for my "table triangle_lvl1"
I see it no prob.
I run from a sql prompt "select * from triangle_lvl1;"
it returns the data
I run "delete * from triangle_lvl1;" and I get an ora-00903: invalid table name????
I then thru SQLNavigator( still logged in as "PRODUCTION") did a right click on the table and was able to truncate the table. I went back to the sql prompt and did a "select * from triangle_lvl1;" it returns O rows as i would expect. I then run "delete * from triangle_lvl1;" and I once again get an ora-00903: invalid table name????
I even tried to grant delete to myself for the table but your not allowed to do that( well at least I get that).
Thanks in advance,
I think the syntax is:
delete from tablename;
Yes, that looks like your problem:
SQL> truncate table test;
SQL> delete from test;
0 rows deleted.
SQL> delete * from test;
delete * from test
ERROR at line 1:
ORA-00903: invalid table name
sometimes its ez to overlook the ez one, lol
the "from" word is optional also.
deletes all the rows in test.