# Am receiving message "'TOAD.TOAD\_PLAN\_TABLE' is old version" - how to upgrade Oracle instance?

**URL:** <https://forums.toadworld.com/t/am-receiving-message-toad-toad-plan-table-is-old-version-how-to-upgrade-oracle-instance/32346>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [January 19, 2015, 5:52pm UTC](https://forums.toadworld.com/t/am-receiving-message-toad-toad-plan-table-is-old-version-how-to-upgrade-oracle-instance/32346 "2015-01-19T17:52:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![david.martin\_312](https://avatars.discourse-cdn.com/v4/letter/d/6f9a4e/32.png) [@david.martin\_312](https://forums.toadworld.com/u/david.martin_312)\
**Post date:** [January 19, 2015, 5:52pm UTC](https://forums.toadworld.com/t/am-receiving-message-toad-toad-plan-table-is-old-version-how-to-upgrade-oracle-instance/32346/1 "2015-01-19T17:52:24Z")

</div>

G’day,

I upgraded my TOAD to 12.5.1.1 but the ‘TOAD\_PLAN\_TABLE’ on the Oracle instance in which I am working must have been created with an older version.

How do I upgrade ‘TOAD\_PLAN\_TABLE’ to the new version?

Maintaining the old entries is not an issue.

David

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [January 20, 2015, 5:19am UTC](https://forums.toadworld.com/t/am-receiving-message-toad-toad-plan-table-is-old-version-how-to-upgrade-oracle-instance/32346/2 "2015-01-20T05:19:25Z")

</div>

Just drop the old table. Next time you do an Explain Plan, Toad will ask you if it can create a new one for you.

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [January 20, 2015, 11:17am UTC](https://forums.toadworld.com/t/am-receiving-message-toad-toad-plan-table-is-old-version-how-to-upgrade-oracle-instance/32346/3 "2015-01-20T11:17:57Z")

</div>

I’d always use original table from sys schema (put “SYS” and “PLAN\_TABLE$” in Oracle General tab… especially after some upgrades to new Oracle version, when DBA should drop old one a recreate a new one manually.

Oracle plan table always has all new columns while toad is only a tool that is trying to follow that…

🙂