Deleting Rows

I have just installed 9i. And I am having problems in deleting rows from tables within SQLPlus.

When I create a table and a field, then insert a value to that field, the SELECT statement on that table works fine. However when I do a DELETE statement, the following error message raises

SQL> delete * from test;
delete * from test

       *
ERROR at line 1:
ORA-00903: invalid table name

I dont understand the error message because the table has been proven to exist by the SELECT statement.

I've even tried using the GRANT statement

I am not able to GRANT delete on the table, obviously because I am logged on as that user. And if I am logged on as another user I can not even see the table to GRANT the permission that way.

I am obviously missing something fundamental here

And would appreciate it if anyone could help

Thanks Karl Received on Tue Apr 08 2003 - 15:29:12 CDT