Database DataWarehousing (MOSC)

MOSC Banner

ORA-12004 - Fast Refresh using PCT without logs

edited Jan 14, 2010 12:40AM in Database DataWarehousing (MOSC) 2 comments
 I am trying to create and use a materialized view based on an underlying partitioned table using Partition Change Tracking (PCT) without using Materialized View logs (see http://www.oracle.com/technology/pub/articles/10gdba/nanda_10gr2dba_part4.html#1). However, when I try to execute the DBMS_MVIEW.REFRESH (<my mv name>, 'F') I get a "ORA-12004" error. My understanding is that as of 10.2 Oracle supports fast refreshes using PCT without materialized view logs. If somebody could give me a detailed example of setting this up I would appreciate it. The article above doesn't give details on all steps.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center