Anita,
I would be a very happy man today if snapshots existed in SE. However,
I have verified the non-existence of snapshots in SE by:
(1) running basic create statements and having them fail
and
(2) filing an iTAR about the existence of snapshots/MVs in SE and
receiving an answer of 'no'
The error is:
SQL create materialized view test_age as select * from age;
ORA-12028: snapshot type is not supported by master site
Chris Rezek wrote:
Anita,
I would be a very happy man today if snapshots existed in SE. However,
I have verified the non-existence of snapshots in SE by:
Chris,
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.
Chris,
Read-only and updatable snapshots/materialized views
are available with the Standard Edition starting with
8.1.5; SE can also be used for the master site for
snapshots/MV's. EE is required only for multi-master
replication and the data warehousing features of MV's
(e.g. summary
Anita - I checked 112591.1 and also filed an iTAR to confirm with Oracle
- there is no materialized view functionality for SE.
Chris - Alas, transportable tablespaces are not available for SE either.
I'm still looking for suggestions. The tables need to be
read-consistent down to the second.
Chris,
If you can do an export of the data you need in a short period of time you could use
the CONSISTANT=Y clause to get a shapshot of your tables.
ROR mª¿ªm
[EMAIL PROTECTED] 08/14/01 03:21PM
Anita - I checked 112591.1 and also filed an iTAR to confirm with Oracle
- there is no
I ordinarily wouldn't correct a misspelling, but in this case, it matters:
it's CONSISTENT, not CONSISTANT.
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, August 14, 2001 3:54 PM
To: Multiple recipients of list ORACLE-L
Chris,
If you
Two thoughts.
1) buy the Enterprise edition
2) export the tables from the database and then load them in.
-Original Message-
From: Chris Rezek [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 13, 2001 5:50 PM
To: Multiple recipients of list ORACLE-L
Subject: Substitute for