How to disable startup triggers

Hi,

Is there a way to disable database startup triggers without dropping them.

I mean is there a init.ora parameter which can be set to do this.

Thanks

no such parameter

The how do you do it.

For example if your startup trigger is causing your database to hang at startup. what do you do in this case.

Thanks

I guess you can disable the triggers. Disable will not drop the drop trigger definition and since the trigger is disabled , so it will not be executed.


Sanjay

Quote:

---

For example if your startup trigger is causing your database to hang at startup. what do you do in this case.

---

Interesting...
If you are still able to connect as sys or internal or privileged user you can disable or drop the trgger.
But if the db hangs due to startup trigger and doesn't allow you to connect at all... Any solution??

Sanjay

Quote:

---

Originally posted by SANJAY_G

Quote:

---

For example if your startup trigger is causing your database to hang at startup. what do you do in this case.

---

Interesting...
If you are still able to connect as sys or internal or privileged user you can disable or drop the trgger.
But if the db hangs due to startup trigger and doesn't allow you to connect at all... Any solution??

Sanjay

---

Ok, let me explain,

I have a startup trigger which executes a java stored procedure . The java stored procedure in turn executes an OS command on a windows 2000 system to start the context server.

This operation hangs. I want to get rid of this trigger so that my database opens without any problem.

Is there any way I can do this.

Thanks

I see 2 ways:
1) replace your external program on simple one to be able to open database;
2) try this http://www.dbasupport.com/forums/sho...threadid=19741
but I am not sure (2) will help you.