Unable to drop view

[chukkala]

Hi

I'm unable to drop a view owned by me. The system hangs when I issue 'DROP VIEW <view name>.

In DBA_OBJECTS the STATUS shows 'VALID'. Is there any other places I need to check?

Can you help to how to drop this problem.

Thanks & Regards
Bhaskara

[marist89]

I would check to see if anybody else has a lock on that view.

[chukkala]

Hi Thanks for your reply.

Can you help me how to check.

Is there any sql for that.

Regards