Forum Stats

  • 3,770,456 Users
  • 2,253,116 Discussions
  • 7,875,463 Comments

Discussions

ORA-20001: Error while Refreshing EMP_MV -12052 -ERROR- ORA-12052:

Hello,

I am usning 12c Db.

I am getting below error while refreshing the MV.

ERROR at line 1:ORA-20001: Error while Refreshing TEST_MV -12052 -ERROR- ORA-12052:cannot fast refresh materialized view TEST_MVORA-06512: at line 36

pastedImage_15.png

I have one MV which based on 2 tables.

I have created MV logs in different schema as below.

CREATE MATERIALIZED VIEW LOG ON TEMP_MASTER_SCHEMA.TABLE1TABLESPACE TEMP_MASTER_SCHEMA_DATAWITH ROWID; CREATE MATERIALIZED VIEW LOG ON TEMP_MASTER_SCHEMA.TABLE2TABLESPACE TEMP_MASTER_SCHEMA_DATAWITH ROWID; 

MV:

CREATE MATERIALIZED VIEW MASTER_SCHEMA.test_mvTABLESPACE master_schema_dataUSING INDEX TABLESPACE master_schema_indexAS  SELECT          col1,col2,col3,col4,col5,col6    FROM temp_master_schema.table1 tab1,         temp_master_schema.table2 tab2    WHERE tab1.col1     =tab2.col2;

This MV I want to do a FAST refresh.

It is working find in all the PTE , cTE and PPE environment.

But in Production is failing.

But If I do COMPLETE refresh then it is working in PROD.

Any suggestion on this issue?