database event trigger [message #50806] |
Mon, 08 April 2002 23:29 |
jose prakash
Messages: 2 Registered: April 2002
|
Junior Member |
|
|
HI,
I have created a database event trigger
"after startup " , and because of some problems
I am not able to startup the oracle database.
and it is showing "end of communication channel"
I have tried connecting as internal. because I heard , the db event triggers will not get fired , if we login as internal or sys.
Can anybody tell the steps involved in startup the database and to disable/drop that trigger??
Thanx in advance
jose
|
|
|
Re: database event trigger [message #50807 is a reply to message #50806] |
Mon, 08 April 2002 23:58 |
Shrikanth
Messages: 16 Registered: April 2002
|
Junior Member |
|
|
hi jose
if you are working on oracle 8x . get connected to svrmgrl and connect as internal . drop the trigger . if the trigger has compilation error then your database will give you error. drop the trigger and now connect it will work.
|
|
|