Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009

    Unanswered: Delete from materialised view

    Hey, i was wondering if the syntax for deleting from a materialised view
    is the same as using the DELETE operator on a standard table?

    Is this right?

    DELETE FROM <View name>
    WHERE  a = b etc

  2. #2
    Join Date
    Nov 2003
    Provided Answers: 23
    A MV is not updateable (i.e. you cannot delete rows from it), it is updated through changes in the base table(s).

    The only exception is, when you have the "Advanced Replication feature" and use the MV to replicate data between two servers.

    To remove rows from the MV, delete them in the base table(s) and refresh the MV

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts