ORA-12004 - Fast Refresh using PCT without logs
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.
0