Can I refresh a materialized view in CF?

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Can I refresh a materialized view in CF?

    I am currently working on a project where we are looking to migrate an existing
    process to use ColdFusion. That process currently executes a call from a DOS
    batch file to refresh an Oracle 9i materialized view. I would like to have
    that refresh executed by using Coldfusion. However, I am not sure how to do
    that.

    Can anyone help me? Can it even be accomplished?
    (I have googled the web on ColdFusion and Materialized view and there is no
    info out there on this topic.)

    Thanks.

    Sheds20 Guest

  2. Similar Questions and Discussions

    1. Refresh view from web. Load data from local
      In the web i set my settings to allow all sites (flash security settings) My flash load some xml and movie files from server. When I "Test movie"...
    2. Not view refresh flash on web
      I have a problem. Compile Player: 7.0 ActionScript: 2.0 Local Playback Security: Access Network Only In the web i set my settings to allow all...
    3. TemplatedControlDesigner - how to refresh design view
      Hi all I have a simple templated control (the one from ASP.NET quickstarts, little modified ->...
    4. Problem with refresh button breaking automatic refresh
      As a public service, I'm posting the solution to a problem I had. The bizarre thing is that I think this should have created an error. Instead, it...
    5. ORA-02266 when refreshing materialized view
      Can you post your MV definition? Most likely you have other tables referencing the MV. Check user_dependencies. - Jusung Yang ...
  3. #2

    Default Re: Can I refresh a materialized view in CF?

    Look a using cfexecute to run the batch file.
    OldCFer Guest

  4. #3

    Default Re: Can I refresh a materialized view in CF?

    Thanks. That was going to be my backup plan if the refresh could not be executed or initiated directly using a ColdFusion command.

    I appreciate the input.

    Sheds20 Guest

  5. #4

    Default Re: Can I refresh a materialized view in CF?

    my host does not allow the use of CFEXECUTE nor CFREGISTRY under any
    circumstances!! Is that a global policy or it is possible to find host that
    allow you to use such tags? If yes where?

    Thank you,

    Dario

    xcoldnet Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139