ORA-30476: PLAN_TABLE does not exist in the user's schema
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-39109: Unprivileged users may not operate upon other users' schemas
ORA-28523: ORACLE and heterogeneous agent are incompatible versions
ORA-01310: requested return type not supported by the lcr_mine function
DRG-11510: encountered unrecoverable error on line string
ORA-30515: suspend triggers cannot have BEFORE type
NNL-00299: Scheduled server cache dump to occur in string
TNS-00113: Failed to open error log file
TNS-04206: Trace Assistant Internal ERROR: Packet Type
NNO-00334: region load failure: ROS admin_region type number unsupported
PCB-00221: OCCURS DEPENDING ON clause not allowed for host variable "string"
ORA-12666: Dedicated server: outbound transport protocol different from inbound
LPX-00268: invalid access method ~1d, must be 0 to ~2d