BUG in DESCRIBE ?

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.

        SQL> create table test as select * from dual;

        Table created.

        SQL> select * from test;

        D
        -
        X

        1 row selected.

        SQL> describe test
        SQL>

And LOOK ! No definition for the table TEST !

I had a look in DBA_SEGMENTS and DBA_TABLES and all the bits and pieces are there but it just doesn't show up in the DESCRIBE command.

I thought this might have been a problem with the way I was creating the table but "CREATE TABLE test ( tt DATE);" succeeds but the table TEST is still invisible to the DESCRIBE command.

I tried it with a table name of FRED (or CAT or DOG or WOMBAT) instead of TEST and it works fine.

Is this a bug ?

-- 

Bruce...        pihlab_at_cbr.hhcs.gov.au

*******************************************************************


* Bruce Pihlamae  --  Database Administration                     *


* Commonwealth Department of Human Services and Health            *

* Canberra, ACT, Australia                        (W) 06-289-7056 *

*=================================================================*


* These are my own thoughts and opinions, few that I have.        *


*******************************************************************

"The more complex the argument gets, the easier it is to refute."
"Killing is wrong!"  -- Trent 'The Uncatchable' Castanaveras