My Oracle Support Banner

Refreshing Materialized View With 'L' Option Raises ORA-32381 Error (Doc ID 3077469.1)

Last updated on MARCH 21, 2025

Applies to:

Oracle Database - Enterprise Edition - Version 23.5 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Goal

This document describes the behavior of the Logical Partition Change Tracking (LPCT) Refresh of a materialized view.

ORA-32381 "LPT FAST REFRESH cannot be used for materialized view" error is returned when trying to refresh a materialized view using 'L' option. 2

The error can be produced by following below steps.

  1. Create materialized view by "create materialized view ..." command
  2. Create LPT by "create logical partition tracking on <table_name>" command
  3. Refresh materialized view with "exec dbms_mview.refresh('<mv_name>',method => 'L')" command

Error ORA-32381 is raised at step 3.

 

Solution

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.