“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:)
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.
Thanks Derya,
Toad sometimes makes life easier but sometimes more and more diffucult 🙂
Thanks for valuable posting!! Its very tough to find this type of error resolution.
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!
yes absolutely correct toad not identify the semicolon. now its working me. thnx a lot