drop view command hangs
I would like to recreate a view.
But the session hangs.
I can't drop this view too.
It is a simple view like this:
create or replace forse view
(t.col1,t.col2,tt.col3,t.col4) as
select col1,col2,col3,col4
from tab1t,tab3 tt
on t.col1 = tt.col1
There is no lock on this object. I looked in v$lock and v$locked objects