Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-30476: PLAN_TABLE does not exist in the user's schema
- 2 Answers
- 4889 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 |
PLS-00308: this construct is not allowed as the origin of an assignment
ORA-30574: Cannot create rollback segment in tablespace with AUTO segment space management
ORA-06705: TLI Driver: remote node is unknown
ORA-01326: compatability of 9.0 or greater required to build into the logstream
DRG-10574: failed to upgrade text index string
O2F-00302: Unable to allocate memory
ORA-24505: cannot change character set id on the handle
PLS-00252: reference to the wrong copy of package STANDARD
VID-00704: invalid input format
TNS-01302: nr err code: number
QSM-00756: the specified workload string is being used by one or more advisor tasks
ORA-36952: (XSFCAST23) You cannot specify a cycle number when querying the string forecasting option.
Oracle Errors 
