1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Trigger on materialized view log tables

Discussion in 'SQL PL/SQL' started by Arunraj, Dec 7, 2016.

  1. Arunraj

    Arunraj Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    INDIA
    Hi Guys,

    Please help with the below query.

    Requirement: To track DML changes on multiple tables and to populate its consolidated records in one master table by having triggers on the MLOG tables.

    Action : I have created triggers on MLOG tables, few of them works and few are failed.

    Query: Need suggestion, Is it advisable to have triggers on MLOG$_TABLES (Materialized view log tables ), If yes , Is there any restriction to have so.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,619
    Likes Received:
    364
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Since you've already asked on Ask Tom and received the same answer I would give this question is considered answered.