Re: Materialized views across a db link

You can't create materialized views with ON COMMIT across a dblink, sorry. They didn't write the trigger to do remote procedure calls. You can set up Multimaster replication with the Synchronous
option, but good luck :-). It puts you out of business if the communications link goes down, and it's hideously complex to set up (and presumably to maintain) All my customers have settled for a
delay, so I use (comparatively) simple snapshots.

To set up a timed update you must make sure you have set job_queue_processes greater than zero on the target db, to allow job processes for the refresh, then either include the refresh information in
your CREATE statement (see the Fine Manual) or create a refresh group with the DBMS_REFRESH package (see the other Fine Manual), if there are 2 or more to keep in sync.

johnm9563_at_netscape.net wrote:

> Anybody using MV`s thru a db link.
>
> I am trying to create a MV that is updated on commit. I can create this view if I
>get I keep it in the same db. I can get a MV that never will be refreshed working
>link. ( What good is that ?)
>
> The query is below
> Platform Irix 6.5 Oracle 8.1.6
>
> Tia
> John
>
> QUERY
> select SYSTEM_CODE_ID,
> SYSTEM_CODE_GROUP_ID,
> LAST_UPDATE_DATETIME,
> LAST_UPDATE_USER_ID,
> LAST_UPDATE_PROGRAM,
> SYSTEM_CODE,
> SYSTEM_CODE_DESC,
> CODE_SEQUENCE_NBR,
> SYSTEM_CODE_REF_NBR,
> SYSTEM_CODE_REF_TEXT,
> ACTIVE_CODE_IND,
> count(*) dummy_count
> from utility.system_code_at_mcdev
> group by SYSTEM_CODE_ID,
> SYSTEM_CODE_GROUP_ID,
> LAST_UPDATE_DATETIME,
> LAST_UPDATE_USER_ID,
> LAST_UPDATE_PROGRAM,
> SYSTEM_CODE,
> SYSTEM_CODE_DESC,
> CODE_SEQUENCE_NBR,
> SYSTEM_CODE_REF_NBR,
> SYSTEM_CODE_REF_TEXT,
> ACTIVE_CODE_IND
> /
>
> __________________________________________________________________
> Get your own FREE, personal Netscape Webmail account today at
>http://webmail.netscape.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: johnm9563_at_netscape.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Mar 05 2001 - 11:50:34 CST