DBMS_REDEFINITION LEAVES A MATERIALIZED VIEW IN COMPILE STATE ERROR

(Doc ID 1273036.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

After using DBMS_REDEFINITION you see a related materialized view
in compile_state=ERROR e.g.

BEGIN DBMS_REDEFINITION.START_REDEF_TABLE('GETS_B2B', 'GETS_B2B_T3_LOCATION',
'GETS_B2B_T3_LOCATIONREORG', NULL, DBMS_REDEFINITION.CONS_USE_ROWID); END;

PL/SQL procedure successfully completed.

select mview_name,compile_state from user_mviews;

MVIEW_NAME COMPILE_STATE
------------------------------ -------------------
GETS_B2B_T3_LOCATIONREORG ERROR







Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms