@#@# I cant delete from table I own ??? ora-00903: invalid table name

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,
SMD

I think the syntax is:

delete from tablename;

(no "*")

Yes, that looks like your problem:
SQL> truncate table test;

Table truncated.

SQL> delete from test;

0 rows deleted.

SQL> delete * from test;
delete * from test
*
ERROR at line 1:
ORA-00903: invalid table name

Dooooh!
thanks tons
sometimes its ez to overlook the ez one, lol

thanks again

the "from" word is optional also.

delete test;



deletes all the rows in test.