Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Describe on view is hanging ...

Re: Describe on view is hanging ...

From: Mike Morgan <mmorga2_at_amfam.com>
Date: 1997/08/01
Message-ID: <01bc9e88$a1b1dba0$7c38c8a5@mxm014pc>#1/1

If it's any consolation, I tried this on Oracle 7.3.2.3 (AIX) and could not reproduce - that is, it works fine for me.

Mike Morgan
Compuware Corp.
mailto:mmorga2_at_amfam.com



peter.lehmann_at_lawsonmardon.com wrote in article <33E18DC6.521F_at_lawsonmardon.com>...
> Hi,
>
> we have the following problem logged at Oracle Hotline with PMS No
> 370424. Bug No seem to be 309166.
>
> 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.
>
> It seems to me that Oracle has finally not solved this problem. Or, I am
> too native to understand the context at all. The workaround mentioned
> works but it is not acceptable for a data warehouse environment.
>
> Any help from your (Oracle) site?
>
> Thanks,
> Peter
>
> peter.lehmann_at_lawsonmardon.com
>
  Received on Fri Aug 01 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US