Tuesday 22 May 2012

ORA-30476: PLAN_TABLE does not exist in the user s schema

ORA-30476: PLAN_TABLE does not exist in the user s schema

Cause: Estimate_Summary_Size uses Oracle SQL EXPLAIN PLAN command to estimate cardinality of the specified select-clause. This requires a table called the PLAN_TABLE in the user s schema. For more information refer to the SQL Reference Manual.

Action: Create the PLAN_TABLE as described for EXPLAIN PLAN. On most systems a script utlxplan.sql will create this table.

No comments:

Post a Comment