RE: Snapshots - Doubt about

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.
dwilliams_at_lifetouch.com

-----Original Message-----
<mailto:eca_at_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" <ORACLE-L_at_fatcity.com> 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.
> dwilliams_at_lifetouch.com
>
>
> -----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: eca_at_siteplanet.com.br
>
> 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: 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com>
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: 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).
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com> 
--
Author: Eriovaldo Andrietta
  INET: eca_at_siteplanet.com.br

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: 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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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: 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).