2 Replies Latest reply: Apr 17, 2007 9:59 AM by 572990 RSS

    ORA-12052: cannot fast refresh materialized view SYS.TT12

    444520
      Hi gurus!
      Just have a go on my codes.
      SQL> create table t1(roll number(2) primary key,name varchar2(10));

      Table created.

      SQL> create table t2(roll number(2) primary key,marks number(3));

      Table created.

      SQL> create materialized view log on t1;

      Materialized view log created.

      SQL> create materialized view log on t2;

      Materialized view log created.
      SQL> ed
      Wrote file afiedt.buf

      1 create materialized view tt12
      2 build immediate
      3 refresh fast
      4 start with sysdate
      5 next sysdate + 1
      6 as
      7 select t1.roll,t1.name,t2.marks from t1,t2
      8* where t1.roll=t2.roll
      SQL> /
      select t1.roll,t1.name,t2.marks from t1,t2
      *
      ERROR at line 7:
      ORA-12052: cannot fast refresh materialized view SYS.TT12

      Is there any remedy?

      Thnaks & Regards,
      Anirban Dey