Home > problem-cause-solution > “ORA-14006: invalid partition name” in TOAD

“ORA-14006: invalid partition name” in TOAD


Problem:

After issueing below SQL from the TOAD editor:

alter table myschema.mytable truncate partition p20101002;

It gives below error:
ORA-14006: invalid partition name

Cause:

TOAD’s engine sometimes cannot correctly evaulate “;” character at the end.

Solution:
Remove “;” character, or execute it from sqlplus which I did for weeks before finding exact cause:)

  1. Mor
    February 17, 2011 at 11:30 am

    Thanks for posting this!
    I just spent an hour trying to understand why a simple drop partition doesn’t work… removing the “;” did the trick!
    such a strange bug. I will post it as a bug in quest’s support.

  2. February 28, 2012 at 5:10 pm

    Thanks Derya,
    Toad sometimes makes life easier but sometimes more and more diffucult 🙂

  3. Ajay Gupta
    December 27, 2013 at 8:41 am

    Thanks for valuable posting!! Its very tough to find this type of error resolution.

  4. September 21, 2014 at 11:22 am

    Superb site you have here but I was curious if you
    realized of any discussion boards that deal with the same topics talked about
    here? I’d really love to be a part of community where I can get advice from other
    experienced individuals that promote the same interest.

    If you have any recommendations, feel free to inform me. Cheers!

  5. Raja
    June 9, 2016 at 10:50 am

    yes absolutely correct toad not identify the semicolon. now its working me. thnx a lot

  1. No trackbacks yet.

Leave a reply to Micheline Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Julian Dontcheff's Database Blog

Distinguished Product Manager - PL/SQL and JSON at Oracle

Bobby Durrett's DBA Blog

Oracle database performance

flashdba

Database Performance in the Cloud

Don Charisma

because anything is possible with Charisma

Carol no Mundo!

Aventuras de uma intercambista a trabalho pelo mundo!

nimaidba

Welcome to the world of Oracle with me....

Tech

News and reviews from the world of gadgets, gear, apps and the web

WordPress.com

WordPress.com is the best place for your personal blog or business site.

Gurcan Orhan's ODI and DWH Blog

Some words about Oracle Data Integrator and Data Warehousing.