Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Base table of materialized views

Re: Base table of materialized views

From: Sakthi , Raj <rajan_sakthi_at_yahoo.com>
Date: Fri, 02 Nov 2001 23:43:45 -0800
Message-ID: <F001.003BBBEB.20011102234518@fatcity.com>

Yeah.. I know I am late...just catching up. If you are still looking for some
workaround...*TEMPORARY* workaround is to use DBMS_SNAPSHOT.SET_I_AM_A_REFRESH (TRUE) and then you can do DMLs. But beware....all replication triggers would be disabled when you set it to true. After you are done set it to false.
HTH
Cheers,
RS
--- 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!?
Find a job, post your resume.
http://careers.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sakthi , Raj
  INET: rajan_sakthi_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 Sat Nov 03 2001 - 01:43:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US