Sherrie,
I'm afraid not. You might want to look into creating
your snapshots off of prebuilt tables. When the
snapshots are dropped the table is left so you could
perform DML on it. I haven't played around with them
enough yet to know if you'll need to do a complete
refresh if you drop the snapshot, perform DML, and
then recreate the snapshot on the prebuilt table.
HTH,
--Anita
- Sherrie.Kubis_at_swfwmd.state.fl.us wrote:
>
> I have posed this question to Oracle support and
> have yet to receive an
> understandable answer, so I thought it best to ask
> the experts.
>
> I used to run under 8.1.5 with compatibility set to
> 8.0. Whenever I
> created a snapshot I had an underlying table snap$_
> that was the physical
> table residing in Oracle. This was great because it
> allowed me to alter
> the data with DML when I needed to (believe me, I
> have my reasons!).
>
> After upgrading to 8.1.6 I set compatibility to 8.1
> so that I could take
> advantage of the HTML generation from SQL and
> probably some other features
> that I can't remember immediately. There is no
> longer a SNAP$_ table, but
> the materialized view is actually a table with the
> same name. Even though
> the object is listed as a table in the data
> dictionary, when I try to
> perform DML I get an error stating that I can't
> update this view.
>
> Oracle has taken away a feature that I have come to
> depend on. Does anyone
> know of a workaround for this problem?
>
> Any insights would be appreciated.
>
> ---------------
> Sherrie Kubis
> Southwest Florida Water Management District
> 2379 Broad Street
> Brooksville FL 34604-6899
>
> Phone: (352) 796-7211, Ext. 4033
> Fax: (352) 754-6776
> Email: Mailto:Sherrie.Kubis_at_swfwmd.state.fl.us
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: Sherrie.Kubis_at_swfwmd.state.fl.us
>
> 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).
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.com
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 Sun Oct 28 2001 - 08:57:27 CST