OraFAQ Forum: Replication » Refresh group

Home » Server Options » Replication » Refresh group (Oracle 9.2.0.4.0,windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Refresh group [message #360510]

Fri, 21 November 2008 04:12

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

hi all,

Please give me brief note on refresh group.Also query required to find out number of MViews present in refresh group.

Thank in advance.

Regards,
Balaji

Report message to a moderator

Re: Refresh group [message #360519 is a reply to message #360510]

Fri, 21 November 2008 04:36

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What did you already search in documentation and dictionary (catalog)?

Regards
Michel

Report message to a moderator

Re: Refresh group [message #360554 is a reply to message #360519]

Fri, 21 November 2008 06:19

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

I could find only some details on refresh group.but not much about it.I believe dba_rchild should give me the details i required.

Report message to a moderator

Re: Refresh group [message #360556 is a reply to message #360554]

Fri, 21 November 2008 06:28

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> select comments from dict where table_name='DBA_RCHILD';
COMMENTS
-----------------------------------------------------------------
All the children in any refresh group.  This view is not a join.

1 row selected.

It seems.

Regards
Michel

Report message to a moderator

Re: Refresh group [message #360559 is a reply to message #360556]

Fri, 21 November 2008 06:38

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Then,could you please tell me the exact view that is required to find the number of mviews in a refresh group.

[Updated on: Fri, 21 November 2008 06:47]

Report message to a moderator

Re: Refresh group [message #360569 is a reply to message #360559]

Fri, 21 November 2008 07:14

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Is this not this one?
Otherwise:
select * from dict where lower(comments) like '%refresh%' and table_name like 'DBA%';

Regards
Michel

Report message to a moderator

Re: Refresh group [message #360665 is a reply to message #360569]

Sat, 22 November 2008 00:18

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello,

ASAIK, Try this

SQL> desc dba_refresh_children
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER                                     NOT NULL VARCHAR2(30)
 NAME                                      NOT NULL VARCHAR2(30)
 TYPE                                               VARCHAR2(30)
 ROWNER                                    NOT NULL VARCHAR2(30)
 RNAME                                     NOT NULL VARCHAR2(30)
 REFGROUP                                           NUMBER
 IMPLICIT_DESTROY                                   VARCHAR2(1)
 PUSH_DEFERRED_RPC                                  VARCHAR2(1)
 REFRESH_AFTER_ERRORS                               VARCHAR2(1)
 ROLLBACK_SEG                                       VARCHAR2(30)
 JOB                                                NUMBER
 NEXT_DATE                                          DATE
 INTERVAL                                           VARCHAR2(200)
 BROKEN                                             VARCHAR2(1)
 PURGE_OPTION                                       NUMBER(38)
 PARALLELISM                                        NUMBER(38)
 HEAP_SIZE                                          NUMBER(38)

SQL> desc dba_repgroup
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAME                                     NOT NULL VARCHAR2(30)
 MASTER                                             VARCHAR2(1)
 STATUS                                             VARCHAR2(9)
 SCHEMA_COMMENT                                     VARCHAR2(80)
 GNAME                                     NOT NULL VARCHAR2(30)
 FNAME                                              VARCHAR2(30)
 RPC_PROCESSING_DISABLED                            VARCHAR2(1)
 OWNER                                     NOT NULL VARCHAR2(30)

SQL> select table_name from dict where table_name like '%REP%';

Ref: http://download.oracle.com/docs/cd/B19306_01/server.102/b14227/rarrcatviews.htm#i43461

Babu

Report message to a moderator

Re: Refresh group [message #360940 is a reply to message #360665]

Mon, 24 November 2008 07:15

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

first of all,i want to say thanks for BABU for providing me such useful link on dba views for refresh group.

michel ,

select * from dict where lower(comments) like '%refresh%' and
table_name like 'DBA%';

The result of the query is below;

DBA_SNAPSHOT_REFRESH_TIMES -- Synonym for DBA_MVIEW_REFRESH_TIMES.

Please let me know the purpose of this query?

[Updated on: Mon, 24 November 2008 07:17]

Report message to a moderator

Re: Refresh group [message #360957 is a reply to message #360940]

Mon, 24 November 2008 08:03

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> select * from dict where lower(comments) like '%refresh%' and 
  2  table_name like 'DBA%';
TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------------------------------------------------
DBA_RCHILD
All the children in any refresh group.  This view is not a join.
DBA_RGROUP
All refresh groups.  This view is not a join.
DBA_REFRESH
All the refresh groups
DBA_REFRESH_CHILDREN
All the objects in refresh groups
DBA_MVIEW_REFRESH_TIMES
All fast refreshable materialized views and their last refresh times for each master table
DBA_TEMPLATE_REFGROUPS
Table for maintaining refresh group information for template.
DBA_SNAPSHOT_REFRESH_TIMES
Synonym for DBA_MVIEW_REFRESH_TIMES

7 rows selected.

The purpose is to learn how to find the answer by yourself.

Regards
Michel

Report message to a moderator