Error in CREATE TABLE of EXPLAIN PLAN table:$plan_table

Last Published: April 25, 2020

Error Message

** Internal Publish Only! This article may contain information that is not intended for external circulation. **

The following error is encountered when running TKPROF:"Error in CREATE TABLE of EXPLAIN PLAN table:$plan_table
ORA-00922: missing or invalid option"


This is caused by Oracle bug 3451410. The bug is unpublished, so it cannot be viewed on Metalink. It is scheduled to be fixed in next release of Oracle 10.2.

Solution or Workaround

Execute the following steps:

  1. Run the script $ORACLE_HOME/rdbms/admin/utlxplan.sql in the schema you want to place the explain table.
  2. Run TKPROF with the TABLE option.
    C:\> SQLPLUS sde/passwd

    SQL> @?/rdbms/admin/utlxplan.sql

    C:\> tkprof <tracefile> <outfile> EXPLAIN = ... TABLE = PLAN_TABLE ...

Article ID:000007676

  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic