ORA-30378: MV_CAPABILITIES_TABLE is not compatible with
Oracle version



ORA-30378: MV_CAPABILITIES_TABLE is not compatible with Oracle version..

Answer / guest

Cause: One or more column definitions in the
MV_CAPABILITIES_TABLE is either missing or incompatible with
the current Oracle version.

Action: Connect to the appropriate schema, DROP TABLE
MV_CAPABILITIES_TABLE and recreate it by invoking the
admin/utlxmv.sql script prior to invoking the
DBMS_MVIEW.EXPLAIN_MVIEW() API.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNF-01001: ds_initialize: workspace initialization failed

1 Answers  


ORA-27199: skgfpst: sbtpcstatus returned error

1 Answers  


ORA-01607: cannot add logfile to the specified instance

1 Answers  


DRG-11008: invalid create index partition parameter string

1 Answers  


ORA-23413: table "string"."string" does not have a materialized view log

1 Answers  






NNO-00804: Error: OCI_STILL_EXECUTE

1 Answers  


ORA-39002: invalid operation

1 Answers  


RMAN-10014: PL/SQL error number on line number column number: string

1 Answers  


TNS-00036: INTCTL: error reading from Navigator or Connection Manager error files

1 Answers  


CLSS-00103: unable to read configuration information for node string

1 Answers  


QSM-02106: mv uses a filter condition in the WHERE or HAVING clause

1 Answers  


ORA-32408: materialized view log on "string"."string" already has new values

1 Answers  


Categories