Friday, August 7, 2020

ORA-03291: Invalid truncate option - missing STORAGE keyword

Users creating objects for development activity and come across below error message when truncating a table

ORA-03291: Invalid truncate option - missing STORAGE keyword

The truncate statement expects STORAGE keywork, either specify DROP STORAGE or REUSE STORAGE 

For ex:- SQL> truncate table dept drop storage ;

I have created this blog post shared with all developers.

Thanks & Regards,
Satishbabu G, Oracle ACE


15 comments:

  1. It is an obligation of gratitude to share information, continue the great work ... I sincerely enjoy researching your website. great asset ...
    https://360digitmg.com/course/data-analytics-using-python-r

    ReplyDelete
  2. There is plainly a ton to consider this. Keep working, remarkable work!

    data science certification malaysia

    ReplyDelete
  3. افضل الخدمات الخاصة باعمال نقل العفش مع الفك والتركيب في الطائف تقدمها افضل شركات نقل عفش بالطائف وهي تعتبر من افضل الشركات المتخصصة في اعمال نقل الاثاث بواسطة فريق عمل مميز ومحترف وسيارات نقل عفش حديثة ومجهزة لأعمال نقل الاثاث بالطائف مقفلة ومبطنة من الداخل وستحصل على افضل خدمات شركات نقل الاثاث بالطائف باحترافية عالية وبالضمان من افضل شركة نقل عفش الطائف المتميزة والمؤهلة

    ReplyDelete
  4. I'm cheerful I found this blog! Every now and then, understudies need to psychologically the keys of beneficial artistic articles forming. Your information about this great post can turn into a reason for such individuals.
    hrdf scheme

    ReplyDelete
  5. I would prescribe my profile is critical to me, I welcome you to talk about this point... hrdf scheme

    ReplyDelete

  6. This is quite charming post you shared, I like the post, an obligation of appreciation is all together for sharing..
    HRDF Scheme

    ReplyDelete
  7. Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.

    DevOps Training in Hyderabad

    ReplyDelete
  8. Great delivery. Outstanding arguments. Keep up the amazing effort. 토토

    ReplyDelete
  9. Hi, i believe that i saw you visited my website so i came to go back the desire?.I’m trying to find issues to improve my website!I suppose its good enough to use some of your ideas!! 바카라

    ReplyDelete
  10. Greetings! Very helpful advice within this article!
    It is the little changes that make the greatest changes. Thanks a lot
    for sharing! 경마

    ReplyDelete
  11. Telecom major’s BSNL Portal for postpaid and prepaid is a new innovative online customer care service for all BSNL Broadband, Fiber to the home, Landline, and mobile clients. Having one account at this new Selfcare BSNL portal user can access all your telecom facilities online at your fingertips. It is a specially invented and upgraded BSNL customer care portal named as BSNL Selfcare and the application allows all new subscriptions, additional facilities and also to lodge the BSNL complaint online about broadband, Selfcare BSNL landline and FTTH (Bharat Fiber), along with some new mobile services to activate in BSNL Portal. BSNL Selfcare is a magical or technological doorway on the web, and it aims to provide all customer facilities through online account and it delivers excellent measurable ongoing customer care updated telecom services through a gateway called Selfcare.

    ReplyDelete