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

Question Posted / guest

2 Answers
5153 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / dheerendra

PLAN_TABLE does not exist in each schema. You need to
create this table into your schema.The DDL comes with each
installation. Execute file UTLXPLAN.SQL in your schema to
create PLAN_TABLE. On unix server it usually remains in
$ORACLE_HOME/rdbms/admin folder.

Is This Answer Correct ?

0 Yes

0 No

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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

2 No

Post New Answer