Error: Error in CREATE TABLE of EXPLAIN PLAN Table: VACISMGR.prof$plan

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: VACISMGR.prof$plan_table
ORA-00922: missing or invalid option"

Cause

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:

Run the script $ORACLE_HOME/rdbms/admin/utlxplan.sql in the schema you want to place the explain table.

Run TKPROF with the TABLE option.

Code:
C:\> SQLPLUS sde/passwd

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

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

Article ID:000007676

Software:

Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Error in CREATE TABLE of EXPLAIN PLAN table: VACISMGR.prof$plan_table

Error Message

Cause

Solution or Workaround

Discover more on this topic