From Sherrie.Kubis@swfwmd.state.fl.us Fri, 26 Oct 2001 05:01:02 -0700 From: Sherrie.Kubis@swfwmd.state.fl.us Date: Fri, 26 Oct 2001 05:01:02 -0700 Subject: Base table of materialized views Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@swfwmd.state.fl.us -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Sherrie.Kubis@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@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).