Re: Describe on view is hanging ...

Ian Sparkes wrote:

> 
>  Did you reissue the grant on the view to user B ?
> 
> >
> >conn B/B
> >desc test7;  <--- DB is hanging!!!
> >
 

> >
> >peter.lehmann_at_lawsonmardon.com

If you do access the view test7 after the recreation of the table in any way as the user who created the table, you do not have problems.

That is, grant view test7 to..., descr view test7, ... select 1 from test7, etc.

This is a kind of workaround which does not correspond to any oracle documentation. Oracle told me, that the problem has something to do with the diana submodul inside the oracle kernel. There is no bug-fixing for 7.1, 7.2, 7.3 available as the problem seems to be very riscy to be solved. Oracle said, that if you do have a huge workload on your db with a lot of page swapping, the problem does not occure ...

Strange answer ...

 peter.lehmann_at_lawsonmardon.com wrote in article

> conn A/A
> create table t_test7 (test_feld char(1));
> create or replace view test7 as select * from t_test7;
> grant select on test7 to B;
>
> conn B/B
> create or replace view test7 as select * from A.test7;
>
> conn A/A
> drop table t_test7; <-- View is INVALID, at A and B. This is ok!
> create table t_test7 (test_feld char(1));
>
>
> conn B/B
> desc test7; <--- DB is hanging!!!
>
> The problem is generic and could be reproduced on 7.1.3 and 7.2.3.
>
> Any help from your (Oracle) site?
>
> Thanks,
> Peter
  Received on Wed Aug 13 1997 - 00:00:00 CEST