** 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"
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.
C:\> SQLPLUS sde/passwd
C:\> tkprof <tracefile> <outfile> EXPLAIN = ... TABLE = PLAN_TABLE ...