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


24 comments:

  1. Packers and Movers Gurgaon Provide Reliable, Safe and Certified Service Provider list, Get Free ***Best Price Quotaition and Compare Charges. ???Hassle free Household Shifting Services, High Quality packing Material, Office Relocation, Car Transportaion, ###Local and Domestic Shifting Service @
    Packers And Movers Gurgaon

    ReplyDelete
  2. Superb post, we enjoyed each and everything as per written in your post. Thank you for this informative article because it’s really helpful, I really like site. @ Packers And Movers Gurgaon

    ReplyDelete
  3. Packers and Movers Chennai Give Safe and Reliable ***Household Shifting Services in Chennai with Reasonable ###Packers and Movers Price Quotation. We Provide Household Shifting, Office Relocation, ✔ ✔ ✔ Local and Domestic Transportation Services, Affordable and Reliable Shifting Service Charges @ Packers And Movers Chennai

    ReplyDelete
  4. 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
  5. There is plainly a ton to consider this. Keep working, remarkable work!

    data science certification malaysia

    ReplyDelete
  6. Get Packers and Movers Jaipur List of Top Reliable, 100% Affordable, Verified and Secured Service Provider. Get Free ###Packers and Movers Jaipur Price Quotation instantly and Save Cost and Time. Packers and Movers Jaipur ✔ ✔ ✔ Reviews and Compare Charges for household Shifting, Home/Office Relocation, ***Car Transportation, Pet Relocation, Bike SHifting @ Packers And Movers Jaipur

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

    ReplyDelete
  8. This is really very nice post you shared, i like the post, thanks for sharing..@ Packers and Movers Kolkata

    ReplyDelete
  9. 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
  10. Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing.data science courses in Hyderabad

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

    ReplyDelete

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

    ReplyDelete
  13. Get Packers and Movers Chandigarh List of Top Reliable, 100% Affordable, Verified and Secured Service Provider. Get Free ###Packers and Movers Chandigarh Price Quotation instantly and Save Cost and Time. ???Packers and Movers Chandigarh Reviews and Compare Charges for household Shifting, Home/Office Relocation, ***Car Transportation, Pet Relocation, Bike SHifting @ Packers And Movers chandigarh

    ReplyDelete
  14. 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
  15. Great delivery. Outstanding arguments. Keep up the amazing effort. 토토

    ReplyDelete
  16. 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
  17. Greetings! Very helpful advice within this article!
    It is the little changes that make the greatest changes. Thanks a lot
    for sharing! 경마

    ReplyDelete
  18. 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