Yes I did.and ora_snpx_SID processes running processess are running.
>From: Scott.Shafer_at_dcpds.cpms.osd.mil
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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:oracledbam_at_hotmail.com]
> > 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_at_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: Scott.Shafer_at_dcpds.cpms.osd.mil
>
>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_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).
Join the world’s 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: oracledbam_at_hotmail.com
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_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).
Received on Tue Apr 23 2002 - 16:03:29 CDT
