5 Replies Latest reply: Nov 18, 2009 11:12 PM by 009 RSS

    truncate table in oracle.

    732261
      i want to truncate my table called l_gsm_pop_gprs_e, i am using below query but its not working its giving error like
      ORA-03291: Invalid truncate option - missing STORAGE keyword.
      can anyone tell me what is the right query to truncate my table

      query:
      truncate table l_gsm_pop_gprs_e nowait drop storage;

      ORA-03291: Invalid truncate option - missing STORAGE keyword

      earlier i was getting this below mention error when i was not using truncate statement.
      ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired


      plz reply
      thnx in advance.