Portuguese

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_MV

ORA-06512: at line 36

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.TABLE1

TABLESPACE TEMP_MASTER_SCHEMA_DATA

WITH ROWID;

CREATE MATERIALIZED VIEW LOG ON TEMP_MASTER_SCHEMA.TABLE2

TABLESPACE TEMP_MASTER_SCHEMA_DATA

WITH ROWID;

MV:

CREATE MATERIALIZED VIEW MASTER_SCHEMA.test_mv

TABLESPACE master_schema_data

USING INDEX TABLESPACE master_schema_index

AS

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?