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.
Oracle DBA and Developer
Click Here to Expand Forum to Full Width