Search notes:

$ORACLE_HOME/rdbms/admin/utlxmv.sql

utlxmv.sql creates a table named mv_capabilities_table that is required by the dbms_mview.explain_mview procedure.

In SQL*Plus, this script can be run like so:

SQL> @?/rdbms/admin/utlxmv

Because this table is rather simple and has no prerequisites or dependencies, the table can also be created with the following create table statement if there is no Oracle installation handy:

create table mv_capabilities_table (
   statement_id      varchar(30),
   mvowner           varchar(30),
   mvname            varchar(30),
   capability_name   varchar(30),
   possible          character(1),
   related_text      varchar(2000),
   related_num       number,
   msgno             integer,
   msgtxt            varchar(2000),
   seq               number
);

Index