Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

truncate table in oracle.

732261Nov 13 2009 — edited Nov 19 2009
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2009
Added on Nov 13 2009
5 comments
10,700 views