Home » Server Options » Replication » Refresh group (Oracle 9.2.0.4.0,windows)
Refresh group [message #360510] Fri, 21 November 2008 04:12 Go to next message
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

Re: Refresh group [message #360519 is a reply to message #360510] Fri, 21 November 2008 04:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What did you already search in documentation and dictionary (catalog)?

Regards
Michel
Re: Refresh group [message #360554 is a reply to message #360519] Fri, 21 November 2008 06:19 Go to previous messageGo to next message
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.

Re: Refresh group [message #360556 is a reply to message #360554] Fri, 21 November 2008 06:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Refresh group [message #360559 is a reply to message #360556] Fri, 21 November 2008 06:38 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Refresh group [message #360665 is a reply to message #360569] Sat, 22 November 2008 00:18 Go to previous messageGo to next message
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)


Or

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

Re: Refresh group [message #360940 is a reply to message #360665] Mon, 24 November 2008 07:15 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Refresh group [message #360975 is a reply to message #360957] Mon, 24 November 2008 08:54 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Thanks for your information.
Re: Refresh group [message #361024 is a reply to message #360975] Mon, 24 November 2008 21:10 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Thanks a lot for your update.

Babu
Previous Topic: Replication between oracle 10g & 11g
Next Topic: DBs not Connected...
Goto Forum:
  


Current Time: Fri Mar 29 03:33:30 CDT 2024