what is a materilized view ?
Dear Freinds, what is a materilized view ? what is the use of it and how to create it. Any docs or notes or white papers will be helpful. TIA, Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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).
RE: what is a materilized view ?
http://www.google.com/search?hl=enlr=ie=UTF-8oe=UTF-8q=materialized+view spell=1 http://oracle.oreilly.com/news/oracle8_0600.html http://technet.oracle.com/products/oracle9i/daily/jul05.html A materialized view is like a view in that it represents data that is contained in other database tables and views; yet it is unlike a view in that it contains actual data. A materialized view is like an index in that the data it contains is derived from the data in database tables and views; yet unlike an index in that its data must be explicitly refreshed. Finally, a materialized view is very much like a snapshot in that an administrator can specify when the data is to be refreshed; but it is unlike a snapshot in that a materialized view should either include summary data or data from many different joined tables. The wonders of Google! ;) HTH Mark -Original Message- Veeraraju_Mareddi Sent: 10 September 2003 12:04 To: Multiple recipients of list ORACLE-L Dear Freinds, what is a materilized view ? what is the use of it and how to create it. Any docs or notes or white papers will be helpful. TIA, Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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).
Re: what is a materilized view ?
That would be a question for Madonna, not for this list. Read The Fine Manual. On 2003.09.10 07:04, Veeraraju_Mareddi wrote: Dear Freinds, what is a materilized view ? what is the use of it and how to create it. Any docs or notes or white papers will be helpful. TIA, Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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).
RE: what is a materilized view ?
ROFLMAO ... What a kidder ... v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: what is a materilized view ? That would be a question for Madonna, not for this list. Read The Fine Manual. On 2003.09.10 07:04, Veeraraju_Mareddi wrote: Dear Freinds, what is a materilized view ? what is the use of it and how to create it. Any docs or notes or white papers will be helpful. TIA, Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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).
RE: what is a materilized view ?
I have a problem with unwillingness to invest effort and do some very basic research from the readily available literature. Oracle has a manual called Database Concepts which is accessible on approximately 87 billion places on the internet, for free, of course. Previous incarnations of this list (and I am a long time member) were, in my opinion, rendered unusable by a flood of trivial questions. I do honestly believe that, in order to fully participate in this list, a person must satisfy certain pre-requisites, knoledge-wise and experience-wise. That is why I'm trying to discourage questions like the one above. My reply was jovial and humorous, but the RTFM was dead serious. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Wednesday, September 10, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Subject: RE: what is a materilized view ? ROFLMAO ... What a kidder ... v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: what is a materilized view ? That would be a question for Madonna, not for this list. Read The Fine Manual. On 2003.09.10 07:04, Veeraraju_Mareddi wrote: Dear Freinds, what is a materilized view ? what is the use of it and how to create it. Any docs or notes or white papers will be helpful. TIA, Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient
RE: what is a materilized view ?
Title: RE: what is a materilized view ? Mladen, I completely agree with you on everything you said here except for the pre-requisite experience-wise. I think this list is good for people at any experience level (including newbies). The issue is when the newbies decide to ask very basic questions like What is a materialized view and you can find the answer to that anywhere. I guess I would still consider myself a newbie because I've only been working with Oracle for the last couple of years, but the one thing tend to do is to do some research before asking a question. I don't see this list as a way to be lazy and not have to look up basic things, but if I'm stumped, or I have an urgent question, I may post to the list while I'm looking for an answer. I think pretty much everyone on this list is understanding and helpful to people at all experience levels. A poster just needs to have a bit of common sense regarding what types of questions they ask. -Scott -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 10, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Subject: RE: what is a materilized view ? I have a problem with unwillingness to invest effort and do some very basic research from the readily available literature. Oracle has a manual called Database Concepts which is accessible on approximately 87 billion places on the internet, for free, of course. Previous incarnations of this list (and I am a long time member) were, in my opinion, rendered unusable by a flood of trivial questions. I do honestly believe that, in order to fully participate in this list, a person must satisfy certain pre-requisites, knoledge-wise and experience-wise. That is why I'm trying to discourage questions like the one above. My reply was jovial and humorous, but the RTFM was dead serious. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Wednesday, September 10, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Subject: RE: what is a materilized view ? ROFLMAO ... What a kidder ... v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 10, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: what is a materilized view ? That would be a question for Madonna, not for this list. Read The Fine Manual. On 2003.09.10 07:04, Veeraraju_Mareddi wrote: Dear Freinds, what is a materilized view ? what is the use of it and how to create it. Any docs or notes or white papers will be helpful. TIA, Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). -- Please see the official ORACLE-L FAQ: http
RE: what is a materilized view ?
Title: Message I stand corrected, you are right. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stefick Ronald S Contr ESC/HRIDDSent: Wednesday, September 10, 2003 10:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: what is a materilized view ? Mladen, I completely agree with you on everything you said here except for the pre-requisite "experience-wise". I think this list is good for people at any experience level (including newbies). The issue is when the newbies decide to ask very basic questions like "What is a materialized view" and you can find the answer to that anywhere. I guess I would still consider myself a "newbie" because I've only been working with Oracle for the last couple of years, but the one thing tend to do is to do some research before asking a question. I don't see this list as a way to be lazy and not have to look up basic things, but if I'm stumped, or I have an urgent question, I may post to the list while I'm looking for an answer. I think pretty much everyone on this list is understanding and helpful to people at all experience levels. A poster just needs to have a bit of common sense regarding what types of questions they ask. -Scott -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 10, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Subject: RE: what is a materilized view ? I have a problem with unwillingness to invest effort and do some very basic research from the readily available literature. Oracle has a manual called "Database Concepts" which is accessible on approximately 87 billion places on the internet, for free, of course. Previous incarnations of this list (and I am a long time member) were, in my opinion, rendered unusable by a flood of trivial questions. I do honestly believe that, in order to fully participate in this list, a person must satisfy certain pre-requisites, knoledge-wise and experience-wise. That is why I'm trying to discourage questions like the one above. My reply was jovial and humorous, but the RTFM was dead serious. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Wednesday, September 10, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Subject: RE: what is a materilized view ?ROFLMAO ... What a kidder ... v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 10, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: what is a materilized view ? That would be a question for Madonna, not for this list. Read The Fine Manual. On 2003.09.10 07:04, Veeraraju_Mareddi wrote:Dear Freinds, what is a materilized view ? what is the use of it and how to create it. Any docs or notes or white papers will be helpful. TIA, Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contactthe sender by email and delete all copies; your cooperation in this regardis appreciated. ** --Please see the official ORACLE-L FAQ: http://www.orafaq.net --Author: Veeraraju_Mareddi 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 messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L (or thename of mailing list you want to be removed from). You may also sendthe HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City
RE: what is a materilized view ?
The opposite of an immaterial view :) Henry -Original Message- Veeraraju_Mareddi Sent: Wednesday, September 10, 2003 7:04 AM To: Multiple recipients of list ORACLE-L Dear Freinds, what is a materilized view ? what is the use of it and how to create it. Any docs or notes or white papers will be helpful. TIA, Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras 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).
RE: what is a materilized view ?
Philosophically speaking, when the scales fall from the eyes of an idealist and he/she becomes a rationalist, they've adopted a materialized view. ;-) But maybe it only exists if you believe it exists. -Original Message- Sent: Wednesday, September 10, 2003 5:04 AM To: Multiple recipients of list ORACLE-L Dear Freinds, what is a materilized view ? what is the use of it and how to create it. Any docs or notes or white papers will be helpful. TIA, Rajuveera -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve 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).
RE: what is a materilized view ?
Having fun, while Jared isn't watching? Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Orr, Steve Sent: Wednesday, September 10, 2003 11:15 AM To: Multiple recipients of list ORACLE-L Philosophically speaking, when the scales fall from the eyes of an idealist and he/she becomes a rationalist, they've adopted a materialized view. ;-) But maybe it only exists if you believe it exists. -Original Message- Sent: Wednesday, September 10, 2003 5:04 AM To: Multiple recipients of list ORACLE-L Dear Freinds, what is a materilized view ? what is the use of it and how to create it. Any docs or notes or white papers will be helpful. TIA, Rajuveera -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman 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).
Re: Materilized view?
Hello I think that this line will cause the job to run every minute: start with sysdate next sysdate+ 1/(24*60). Change it to: start with sysdate next sysdate+ 1/(24) IMHO Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 9:18 PM Hi 8.1.6.0 I used materialized view and used following query create materialized view vname refresh fast with primary key start with sysdate next sysdate+ 1/(24*60) as (select * from xxx.abc@test); I want to refresh materialized view every hour.Is above query correct?But i am not looking refreshment. Let me know what things i check and correct to do for refreshment. Thx -seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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).
RE: Materilized view?
Hello Seema, It seems you are trying to run REFRESH every minute (1) instead of very hour.. Use start with sysdate next sysdate+ 1/24 Instead of start with sysdate next sysdate+ 1/(24*60) HTH Nikunj From: Seema Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Materilized view? Date: Tue, 23 Apr 2002 13:03:29 -0800 Yes I did.and ora_snpx_SID processes running processess are running. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Materilized view? Date: Tue, 23 Apr 2002 11:44:21 -0800 Beer is a very good refreshment option. Seriously, have you configured your job_queue_processes parameter in your init.ora? Are there any ora_snpx_SID processes running for your database? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 2:19 PM To:Multiple recipients of list ORACLE-L Subject: Materilized view? Hi 8.1.6.0 I used materialized view and used following query create materialized view vname refresh fast with primary key start with sysdate next sysdate+ 1/(24*60) as (select * from xxx.abc@test); I want to refresh materialized view every hour.Is above query correct?But i am not looking refreshment. Let me know what things i check and correct to do for refreshment. Thx -seema -- 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). _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: H elp_me 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).
Materilized view?
Hi 8.1.6.0 I used materialized view and used following query create materialized view vname refresh fast with primary key start with sysdate next sysdate+ 1/(24*60) as (select * from xxx.abc@test); I want to refresh materialized view every hour.Is above query correct?But i am not looking refreshment. Let me know what things i check and correct to do for refreshment. Thx -seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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).
RE: Materilized view?
Beer is a very good refreshment option. Seriously, have you configured your job_queue_processes parameter in your init.ora? Are there any ora_snpx_SID processes running for your database? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Subject: Materilized view? Hi 8.1.6.0 I used materialized view and used following query create materialized view vname refresh fast with primary key start with sysdate next sysdate+ 1/(24*60) as (select * from xxx.abc@test); I want to refresh materialized view every hour.Is above query correct?But i am not looking refreshment. Let me know what things i check and correct to do for refreshment. Thx -seema -- 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).
RE: Materilized view?
Yes I did.and ora_snpx_SID processes running processess are running. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Materilized view? Date: Tue, 23 Apr 2002 11:44:21 -0800 Beer is a very good refreshment option. Seriously, have you configured your job_queue_processes parameter in your init.ora? Are there any ora_snpx_SID processes running for your database? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Subject:Materilized view? Hi 8.1.6.0 I used materialized view and used following query create materialized view vname refresh fast with primary key start with sysdate next sysdate+ 1/(24*60) as (select * from xxx.abc@test); I want to refresh materialized view every hour.Is above query correct?But i am not looking refreshment. Let me know what things i check and correct to do for refreshment. Thx -seema -- 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). _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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).
Re: Materilized view?
Did you create MATERIALIZED VIEW LOG on base table? Igor Neyman, OCP DBA [EMAIL PROTECTED] Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 3:18 PM Hi 8.1.6.0 I used materialized view and used following query create materialized view vname refresh fast with primary key start with sysdate next sysdate+ 1/(24*60) as (select * from xxx.abc@test); I want to refresh materialized view every hour.Is above query correct?But i am not looking refreshment. Let me know what things i check and correct to do for refreshment. Thx -seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman 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).
Re: Materilized view?
yes,i did From: Igor Neyman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Materilized view? Date: Tue, 23 Apr 2002 12:58:22 -0800 Did you create MATERIALIZED VIEW LOG on base table? Igor Neyman, OCP DBA [EMAIL PROTECTED] Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 3:18 PM Hi 8.1.6.0 I used materialized view and used following query create materialized view vname refresh fast with primary key start with sysdate next sysdate+ 1/(24*60) as (select * from xxx.abc@test); I want to refresh materialized view every hour.Is above query correct?But i am not looking refreshment. Let me know what things i check and correct to do for refreshment. Thx -seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman 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). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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).