Re: Materialized View/Snapshot without Triggers?

From: JamesLane <JamesLane03_at_yahoo.com>
Date: Wed, 25 Jun 2003 16:37:48 +0000
Message-ID: <3042319.1056559068_at_dbforums.com>

I read in an Oracle manual:

To disable all local replication triggers for snapshots at your current site, set the internal refresh variable to TRUE by calling SET_I_AM_A_REFRESH, as shown in the following example:

DBMS_SNAPSHOT.SET_I_AM_A_REFRESH(value => TRUE);

Once again, please remember i'm still very new at Oracle, but would this script be my answer?

--
Posted via http://dbforums.com

Received on Wed Jun 25 2003 - 18:37:48 CEST

This message: [ Message body ]
Next message: GSDRTC1: "Re: Help needed getting BC4J in Jdeveloper to recognize Rowid and Primary Key info in a MySql database"
Previous message: LKBrwn_DBA: "Re: Inconsistent Query Results"
In reply to: JamesLane: "Materialized View/Snapshot without Triggers?"
Next in thread: Simeon Dimitrov: "Re: NLS_DATE_FORMAT with SOL Loader"
Reply: sybrandb_at_yahoo.com: "Re: Materialized View/Snapshot without Triggers?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message