#8361: Refresh Group Editor | Aqua Data Studio

NikolayMetchev reported 2013-02-20T09:10:02Z · last modified 2013-04-03T19:47:25Z

Refresh Group Editor

Dev	NielsGron
QA	SachinPrakash

Priority	Low
Complexity	Unknown

Component	App - Schema Browser
Version	Future - .9

Hello,

It would be good if a refresh group editor was added to ADS. I think refresh groups are Oracle specific.

That would allow you to view and edit refresh group members as well as other refresh group parameters.

2 attachments

Screenshot.png

2013-04-01T16:48:59Z

73 KB
ads tree node

2013-04-01T19:29:55Z

87 KB

All Comments (2) Change History

SachinPrakash 2013-02-20T17:45:36Z

http://www.dba-oracle.com/t_materialized_view_refresh_group.htm

@ivangron: please investigate to determine level of effort. This is a customer request.

ivangron 2013-04-03T17:50:50Z · (edited)

Oracle SQL Developer works with refresh groups as dbms jobs; attach screen shot.

DBMS Jobs

-- refresh group

-- GUI -- You can not modify anything at the gui level, but the following action drop downs allow you to modify an item at a time.

-- Actions

-- Force Broken // BEGIN DBMS_JOB.BROKEN(23, TRUE); END;

-- Force Unbroken // BEGIN DBMS_JOB.BROKEN(23, FALSE, ); END;

-- instance // BEGIN DBMS_JOB.instance(23, <instance>); END;

-- Interval // BEGIN DBMS_JOB.interval(23, <'interval'>); END;

-- Change // BEGIN DBMS_JOB.change(23, <'what'>,<nextdate>, <'interval'>); END;

-- Set Next Date // BEGIN DBMS_JOB.next_date(23, <nextdate>); END;

-- Remove Job // BEGIN DBMS_JOB.remove(23); END;

-- Run Job // BEGIN DBMS_JOB.run(23); END;

-- What // BEGIN DBMS_JOB.what(23, <'what'>); END;

-- REFRESH // BEGIN DBMS_REFRESH.REFRESH('"HR"."REF_GROUP_1"'); END;

-- FREEZE

Currently we only show the list in the node. To create a java GUI we would need:

1.) Extract object info.

2.) Create / Alter / Drop statements.

3.) Create GUI

Assigning issue to niels for further discussion....

Search Tips

Aqua Data Studio / nhilam

Refresh Group Editor

2 attachments

Issue #8361

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Refresh Group Editor

2 attachments

Issue #8361

Completion