| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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" <oracledbam_at_hotmail.com>
>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 13:03:29 -0800
>
>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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: H elp_me INET: good_dba_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 Wed Apr 24 2002 - 18:08:23 CDT
 |
 |