Re: BUG in DESCRIBE ?

From: Rod Anderson <andersr_at_iia.org>
Date: 10 Aug 1994 21:07:41 -0400
Message-ID: <4YKHkmqOpAF1068yn_at_iia.org>


In article <1994Aug2.154005.1_at_cbr.hhcs.gov.au>, pihlab_at_cbr.hhcs.gov.au (Bruce Pihlamae) wrote:
>
> I was tinkering around with "CREATE TABLE test AS SELECT * FROM dual;"
> and discovered this bug(?) in Oracle 7.0.13 and was wondering if anbyone
> had encountered it before.
>

[ Stuff Deleted ]

I remember running into a similar problem with Version 6 (yes we are still in the dark ages of Data General MVs).

I think it turned out to be a problem with synonyms and/or views with the same name ``TEST''. Check out the ALL_xxx tables of the data dictionary tables looking for other objects named TEST that you have access to.

Good luck,
  Rod Received on Thu Aug 11 1994 - 03:07:41 CEST

Original text of this message