ORA-30381: REWRITE_TABLE is not compatible with Oracle version



ORA-30381: REWRITE_TABLE is not compatible with Oracle version..

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07484: snlkput: cannot convert(put) lock.

1 Answers  


ORA-39114: Dump files are not supported for string jobs

1 Answers  


ORA-09881: sstasfre/sstasdel: shmdt error, unable to detach tas read page

1 Answers  


ORA-24416: Invalid session Poolname was specified.

1 Answers  


QSM-02162: the detail table does not have a materialized view log

1 Answers  






RMAN-06153: validation failed for datafile copy

1 Answers  


NCR-01010: NCRS: Invalid network address length.

1 Answers  


ORA-29356: These parameters can be specified only for directives that refer to consumer groups

1 Answers  


ORA-25197: an overflow segment already exists for the indexed-organized table

1 Answers  


ORA-00267: name of archived log file not needed

1 Answers  


DRG-11210: format column must be a char, varchar, or varchar2 type

1 Answers  


DRG-11422: linguistic initialization failed

1 Answers  


Categories