This discussion is archived
2 Replies Latest reply: Feb 15, 2013 4:06 AM by PierfrancescoGirolami RSS

Refresh Group

PierfrancescoGirolami Newbie
Currently Being Moderated
Hi all,
how can I find and manage my Refresh Group with SQLDeveloper? I see subnode about Tables, Views, Procedures, ... but nothing about Refresh Group... I've found some information on the "DBMS Jobs" folder but it's not enough...
Any help?

Thanks in advance,
Pierfrancesco
  • 1. Re: Refresh Group
    Gary Graham Expert
    Currently Being Moderated
    Hi Pierfrancesco,

    It looks like a feature request was made for this on the SQL Developer Exchange (http://sqldeveloper.oracle.com/):
    https://apex.oracle.com/pls/apex/f?p=43135:7:1814400126473::NO:RP,7:P7_ID:18761

    but there may have been some confusion over the wording of the request since only one member of the community voted for it. And, from the comment, without seeming to understand the part about "refresh groups". The request was accepted (and implemented with respect to schedules/jobs for 3.1 and 3.2), but apparently not the refresh group portion.

    You may wish to add another feature request explicitly for refresh groups. It seems like an important feature for database administration.

    For now, if you wish to create refresh groups for materialized views, set start dates, run intervals, and add specific mviews to the groups, you will have to roll your own. Once a refresh group exists with valid schedule properties, the database will run it but I am not certain which job name does that.

    There is currently one reference to REFRESH_GROUP in our code. It occurs in Views -> DBA -> Data Pump in the Include/Exclude filter selector of the Import/Export wizards.

    Regards,
    Gary
    SQL Developer Team

    Edited by: Gary Graham on Feb 8, 2013 11:26 PM
    Accepted for 3.0, but implementation began with 3.1 with improvements in 3.2
  • 2. Re: Refresh Group
    PierfrancescoGirolami Newbie
    Currently Being Moderated
    Hi Gary,
    thanks a lot for your reply. I'm going to add a new feature request because, in some kind of project, managing Refresh Group is a very usefull chance.

    Thanks again.
    Bye,
    Pierfrancesco

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points