enabling/disabling an oracle trigger


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting enabling/disabling an oracle trigger
# 1  
Old 12-16-2008
enabling/disabling an oracle trigger

hi,

i want to disable and then enable an oracle trigger through shell script.

Please tell me how it can be done?
# 2  
Old 12-16-2008
Perhaps you should check out this web page

ORACLE-BASE - Oracle Shell Scripting
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help not trigger the trap

mainpid=$$ (trap "echo timeout" SIGTERM SIGKILL SIGINT; sleep 5; kill $mainpid) & watchdogpid=$! sleep 10 #do something kill $watchdogpid I design a timeout function script I don't see the echo "timeout" is on the screen (1 Reply)
Discussion started by: yanglei_fage
1 Replies

2. Shell Programming and Scripting

Automatic script trigger

Hi, I'm looking for a way to solve the following scenario: A shell should automatically trigger / run when a text file is placed or present at a specific location. My idea - to create a cron / anacron for every minute and inside that i will call a temp script. Temp script will move to my... (9 Replies)
Discussion started by: Gautham
9 Replies

3. Shell Programming and Scripting

Trigger functionality in Unix

Hi, I want a script , which searches the log for the term/phrase "JFSnapshotService::systemSnapshot: Starting data capture. This may take awhile depending upon system workload." and if there is some logging like this, it has to mail me that this data capture process is happening., Below is... (2 Replies)
Discussion started by: cratercrabs
2 Replies

4. Shell Programming and Scripting

Disabling and enabling the cron

Hi All, Please tell me what is command to disable and enable the cron in unix. Thanks in Advance. Regards, Sindu (5 Replies)
Discussion started by: indira_s
5 Replies

5. Shell Programming and Scripting

disabling and enabling the crontab

Hi All, I need disable all the crontab job in the cron and then later have to enable the crontab job by shell scripting. or otherwise disable the cron and enable cron again by means of unix shell scripting. Please can you one help me out in this. Thanks in Advance. Regards, Sindu (2 Replies)
Discussion started by: indira_s
2 Replies

6. UNIX and Linux Applications

update trigger

hi all, i hope i am posting this /beginner) question in the right forum: i want to create an update trigger, which rolls back a transaction if a record of a table is updated. the table has - amongst others - a field 'statusid' - if a record in this table has the statusid X and it is attempted... (0 Replies)
Discussion started by: kalinkula
0 Replies

7. Shell Programming and Scripting

Trigger with condition

If test.ksh is successful then I have a sequence of script which needs to execute automatically. Is it possible to capture the return code to execute the next script automatically? what is better way of doing this. (4 Replies)
Discussion started by: zooby
4 Replies

8. Shell Programming and Scripting

Trigger Enter

Hello, I need to trigger every time enter has been clicked while some one on terminal i tried to googleit but with out result any idea ?? thanks in advance (3 Replies)
Discussion started by: AYAK
3 Replies
Login or Register to Ask a Question