OraFAQ Forum: Server Administration » should not perform any Db operation on SAT , SUNDAY ....

Home » RDBMS Server » Server Administration » should not perform any Db operation on SAT , SUNDAY ....

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

should not perform any Db operation on SAT , SUNDAY .... [message #54888]

Fri, 13 December 2002 05:19

Ramki
Messages: 26
Registered: September 2002

Junior Member

Hi All,

My application should not perform any Db operation on SAT , SUNDAY , and in all National holiday
and before 9:00 am and 6:00 pm on all working day

how can I achieve this.

thanks
-Ramki

Report message to a moderator

Re: should not perform any Db operation on SAT , SUNDAY .... [message #54889 is a reply to message #54888]

Fri, 13 December 2002 05:38

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

hello,
This u can acheive by setting before insert/update/delete triggers on all the tables or before startup trigger
and handle the condition as
if to_char(sysdate,'day')='saturday' ...other cond's then
Raise_application_error(-20000,' Today Holiday');
end if;

sai

Report message to a moderator

Re: should not perform any Db operation on SAT , SUNDAY .... [message #54893 is a reply to message #54888]

Fri, 13 December 2002 06:55

siddharth
Messages: 16
Registered: May 2001

Junior Member

Hi,

You can set the database in restricted mode (ALTER SYSTEM ENABLE&#124DISABLE RESTRICTED SESSION) during the weekends and holidays. Grant 'restricted session' prevledge to those users whom you want to be allowed to log on.

HTH,
Siddharth

Report message to a moderator

Previous Topic:	PL/SQL Package Access
Next Topic:	Query Performance issues...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 18:19:13 CST 2024