Eriovaldo As I said, Oracle now refers to snapshots as materialized views. You will need to paste the links I have provided back together.
>From the Oracle8i Replication Manual, Chapter 3, Snapshot Concepts "Oracle uses snapshots, also referred to as materialized views" http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76959/mvie w.htm#26336 <http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76959/mvi ew.htm#26336> >From the Oracle9i SQL Reference, Create Materialized View Statement When you create a materialized view, Oracle creates one internal table and at least one index, and may create one view, all in the schema of the materialized view. http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920 /a96540/statements_63a.htm#2063795 <http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.92 0/a96540/statements_63a.htm#2063795> >From the Oracle9i Database Concepts Manual, Chapter 21, Data Integrity You can place deferred unique and foreign key constraints on materialized views, allowing fast and complete refresh to complete successfully. http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920 /a96524/c22integ.htm#11235 <http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.92 0/a96524/c22integ.htm#11235> I hope this provides the clarification you seek. Even better, create a materialized view and then create an index on it to prove to yourself how this works. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- <mailto:eca@;siteplanet.com.br> ] Sent: Thursday, October 31, 2002 2:39 AM To: Multiple recipients of list ORACLE-L Dennis : Is there any documento that explain all the resources about snapshot ? I had read the Oracle Documentation, but when i am reading about snapshot I don't see about index , understand ? I would like a document specific about snapshot. Regards Eriovaldo ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, October 31, 2002 2:48 AM > Eriovaldo - Oracle is moving to referring to snapshots as materialized > views, and yes you can put an index on them. > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Wednesday, October 30, 2002 7:04 PM > To: Multiple recipients of list ORACLE-L > > > Friends > > I would like to know about snapshots. > > Can I create a index on snapshot ? How to do it ? > Why refresh with rowid is not recomended ? > How to do when master table doesn't have a PK ? > > Regards > > Eriovaldo > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> > -- > Author: Eriovaldo Andrietta > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com> > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com> > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com> San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
