Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Substitute for Materialized Views/Snapshots?

Re: Substitute for Materialized Views/Snapshots?

From: A. Bardeen <>
Date: Sat, 18 Aug 2001 06:24:31 -0700
Message-ID: <>


I'm confused by your statement "there is no materialized view functionality for SE" as this is completely incorrect.

Read-only snapshots (called materialized views in 8i) have ALWAYS been available with Standard Edition (well, at least since 7.3) as they're considered Basic Replication. Note: 112591.1 clearly states that Basic Replication (which now includes updatable MV's) is available with SE.

Per note: 112591 "Oracle8i server fully supports bi-directional replication with automated conflict detection and resolution. Supported configurations include a single updatable master site with multiple updatable or read-only snapshot sites."

The only materialized view functionality that is not supported in standard edition is the advanced data warehousing features as I mentioned before (e.g. summary management).

I've set up updatable-MV environments in 8i using only SE for both the master and MV sites, so I know that it is possible and supported.

I don't know of any way to have mulitiple DDL statements or transactions maintain read consistency to the same point-in-time as the first statement. The "set transaction isolation level serializable" command doesn't apply to DDL and is released as soon as a commit or a rollback is issued. So the implicit commit in a CTAS wouldn't work.

I suppose you could mimic this by deleting all the rows in the 5 tables and then doing an statement to populate them, but depending on the size of the tables you'd need a fairly large RBS on the target site and the RBS's on the source site would need to be properly sized to avoid ORA-1555 "snapshot too old" errors.

I still don't see why you think read-only snapshots/MV's are not an option. Have you tried to create one and gotten an error? If so, what's the error message? Perhaps it has nothing to do with the fact that you're running SE.


Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
Please see the official ORACLE-L FAQ:
Author: A. Bardeen

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: (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 Sat Aug 18 2001 - 08:24:31 CDT

Original text of this message