Materialized View Fast Refersh Using Point In Time Dbms_flashback.Enable_at_time() returns error "ORA-8182: operation not supported while in Flashback mode" (Doc ID 1394292.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms


Materialized view fast refersh using point in time dbms_flashback.enable_at_time() returns error ORA-8182:


SQL> execute dbms_flashback.enable_at_time(TIMESTAMP '2011-12-13 13:44:51');

PL/SQL procedure successfully completed.

SQL> EXECUTE DBMS_MVIEW.REFRESH('TT1_MV','F');
BEGIN DBMS_MVIEW.REFRESH('TT1_MV','F'); END;

*
ERROR at line 1:
ORA-08182: operation not supported while in Flashback mode
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2566
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2779
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2748
ORA-06512: at line 1

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