truncate table in oracle.
732261Nov 13 2009 — edited Nov 19 2009i 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.