Hi
I'm unable to drop a view owned by me. The system hangs when I issue 'DROP VIEW.
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
Printable View
Hi
I'm unable to drop a view owned by me. The system hangs when I issue 'DROP VIEW.
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
I would check to see if anybody else has a lock on that view.
Hi Thanks for your reply.
Can you help me how to check.
Is there any sql for that.
Regards