DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

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

  1. #1
    Join Date
    Oct 2000
    Posts
    103

    Question

    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

  2. #2
    Join Date
    Nov 2000
    Posts
    245

    I think the syntax is:

    delete from tablename;

    (no "*")

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    Jeff Hunter

  4. #4
    Join Date
    Oct 2000
    Posts
    103

    Talking

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

    thanks again

  5. #5
    Join Date
    Aug 2000
    Posts
    462
    the "from" word is optional also.

    delete test;



    deletes all the rows in test.
    Oracle DBA and Developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width