1 Reply Latest reply: Jul 6, 2010 10:56 AM by user522961 RSS

    ORA-12032: cannot use rowid column

    user522961
      Hi,
      on 8.1.7 I have the following error :
      ORA-12032: cannot use rowid column from materialized view log on "string"."string"
      The solution is :
      Action: A complete refresh is required before the next fast refresh. Add ROWID columns to the materialized view log, if required.


      How can I do a complete refresh before the next fast refresh or Add ROWID columns ? How to know if Add ROWID columns is required ?
      Thank you.

      PS :
      my script is :
      ................
      ..............
      START WITH TO_DATE('06-jul-2010 17:57:48','dd-mon-yyyy hh24:mi:ss')
      NEXT SYSDATE+1/24
        • 1. Re: ORA-12032: cannot use rowid column
          Chinar
          user522961 wrote:
          Hi,
          on 8.1.7 I have the following error :
          ORA-12032: cannot use rowid column from materialized view log on "string"."string"
          The solution is :
          Action: A complete refresh is required before the next fast refresh. Add ROWID columns to the materialized view log, if required.


          How can I do a complete refresh before the next fast refresh or Add ROWID columns ? How to know if Add ROWID columns is required ?
          Thank you.
          run above
          EXECUTE DBMS_MVIEW.REFRESH('MV_NAME','C');