LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  DBMS_SNAPSHOT command

    Employee
    Posted 07-24-2012 20:00

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: alyon

    Hi All,

    I need to refresh a materialized view of an oracle DB.

    I am trying following script in the DB execute node:

    sqlNonSelect("DBMS_SNAPSHOT.REFRESH('MV_MT3_TELEDE X','c')")
    sqlCommit()


    But the node is failing with "invalid SQL statement" error.

    Can anyone advise how can I refresh a view using lavastorm?


    Regards
    Anshul


  • 2.  RE: DBMS_SNAPSHOT command

    Employee
    Posted 07-25-2012 06:55

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: henk01

    Hi Anshul,

    You may want to try:

    sqlNonSelect("call DBMS_SNAPSHOT.REFRESH('MV_MT3_TELEDE X','c')")


    Best Regards,

    Henk