ORA-30476: PLAN_TABLE does not exist in the user's schema
- 2 Answers
- 4391 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
ORA-19906: recovery target incarnation changed during recovery
ORA-24787: remote cursors must be closed before a call completes
ORA-22288: file or LOB operation string failed string
TNS-00073: * stop/abort - stop the process_name
NID-00415: Change of database name and database ID failed.
NNL-00501: set|show log_stats_interval [<seconds>] [<server_list>] : set|show the server's statistic counter logging interval
ORA-06977: X.25 Driver: X.25 Level 2 failure
ORA-38403: attribute set name may not be longer than 22 characters
ORA-24068: cannot start queue string, queue table string is being migrated
ORA-01532: cannot create database; instance being started elsewhere
NNL-00234: Auto-refresh failure-retry expiration period is currently string
ORA-30737: cannot create subtable of a type which is not a subtype of the type of the supertable
Oracle Errors 
