cannot create a trigger

[chron999x]

V.7

I right click on the Triggers. Select new and the software hangs. I have to kill and restart. I have not been able to create a trigger after trying about 10 times.

any thoughts?

 

[Marco Kalter]

When you create a new trigger, the trigger template is displayed, and the table/view list is populated with the following query:

select lower(object_name) from user_objects
where object_type in ('TABLE', 'VIEW')
order by object_type, object_name

Perhaps this query is very slow on this database? Can you verify?