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-33454: (ESDREAD07) Discarding compiled code for workspace object because number is now string workspace object, whereas it was string workspace object when the code was compiled.

1 Answers  


DRG-13307: 'off'=string and 'len'=string references character past end-of-file of string character document, at line string

1 Answers  


LRM-00101: unknown parameter name 'string'

1 Answers  


ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected

1 Answers   CTS,


PLS-00322: declaration of a constant 'string' must contain an initialization assignment

1 Answers  






ORA-02199: missing DATAFILE/TEMPFILE clause

1 Answers  


SQL-02113: Unable to open message file

1 Answers  


ORA-22278: must update the LOB only through the LOB buffers

1 Answers  


ORA-00395: online logs for the clone database must be renamed

1 Answers  


ORA-33217: (CINSERT20) Custom member values cannot be added to concat dimension workspace object, or to any of its bases, because it is not defined as UNIQUE.

1 Answers  


ORA-14049: invalid ALTER TABLE MODIFY PARTITION option

1 Answers  


ORA-00606: Internal error code

1 Answers  


Categories