Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to Edit or Drop a trigger

bootstrapDec 7 2015 — edited Dec 8 2015

Hi,

in my database I am not able to Drop or Edit a trigger.

For all other trigger everything is fine. But for a specific trigger I am not able to modify or delete it.

SQL PLUS editor is getting handed when I fire drop trigger command.

Can you please help.

DB Details : Oracle Database 10g Release 10.2.0.4.0 - 64bit Production

PL/SQL Release 10.2.0.4.0 - Production

I have checked Table is not locked.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 5 2016

Added on Dec 7 2015

#general-database-discussions

9 comments

2,149 views