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 --- [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
