OraFAQ Forum: Server Utilities » SCRIPT FOR REFRESH

Home » RDBMS Server » Server Utilities » SCRIPT FOR REFRESH

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SCRIPT FOR REFRESH [message #155610]

Tue, 17 January 2006 11:46

feroze
Messages: 144
Registered: September 2005
Location: chicago

Senior Member

Hi

I want to write a shell script to execute this code


First connect to DATABASE
execute DBMS_REFRESH.REFRESH('PM_DBA.NPM_MV');

and then make this as crown job to run every 10 minutes.

Some steps in writing this script.
Thanks

Report message to a moderator

Re: SCRIPT FOR REFRESH [message #155642 is a reply to message #155610]

Tue, 17 January 2006 14:58

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Seems to me it would be easier to make it a DBMS_JOB rather than a cronjob, which would require an environmentto be set up, etc.

Have a look at DBMS_JOB.

Report message to a moderator

Previous Topic:	commit to the end of the load
Next Topic:	Database Management issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 03:53:33 CDT 2024