Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-30476: PLAN_TABLE does not exist in the user's schema
- 2 Answers
- 5069 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-12714: invalid national character set specified
ORA-14022: creation of LOCAL partitioned cluster indices is not supported
DRG-11721: thesaurus string is empty
PLS-00204: function or pseudo-column 'string' may be used inside a SQL statement only
ORA-00268: specified log file does not exist 'string'
ORA-07216: slghst: gethostname error, unable to get name of current host.
LSX-00244: invalid NCName "~S"
ORA-15072: command requires at least string failure groups, specified only string
ORA-25441: duplicate column value for table alias: string
LSX-00111: type "~S" contains invalid facets
ORA-33006: (XSAGDNGL02) The relation workspace object is not related to itself.
ORA-19655: cannot switch to incarnation with different resetlogs data
Oracle Errors 
