Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-30476: PLAN_TABLE does not exist in the user's schema
- 2 Answers
- 5062 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-02752: osnfsmmap: illegal shared memory address
NCR-03026: NCRO: The result buffer has overflowed
PLS-00428: an INTO clause is expected in this SELECT statement
ORA-25451: too many attribute values for variable: string
PCC-02132: CMD-LINE: Could not allocate memory
ORA-38718: Invalid thread number specified in the DUMP FLASHBACK command.
ORA-16160: Cannot change protected standby database configuration
ORA-02766: Invalid maximum of request descriptors
LFI-01505: fclose() failed(OSD return value = string) in string.
ORA-01658: unable to create INITIAL extent for segment in tablespace string
QSM-02134: agg(expr) requires correspondng MAX(expr) function
ORA-31408: invalid value specified for begin_scn or end_scn
Oracle Errors 
