Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-30476: PLAN_TABLE does not exist in the user's schema
- 2 Answers
- 4948 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-16600: Failover operation can only be submitted at target database.
ORA-23386: replication parallel push cannot create slave processes
QSM-01039: selection present on right hand side of an outer join
ORA-38700: Limit of string flashback database logs has been exceeded.
ORA-13288: point coordinate transformation error
ORA-31638: cannot attach to job string for user string
DRG-50918: mismatched close escape character
ORA-01286: start interval required
IMG-00705: unsupported or corrupted input format
ORA-33219: (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.
ORA-39703: server version and script version do not match
ORA-24397: error occured while trying to free connections
Oracle Errors 
