Wednesday, December 07, 2011

Two faced dual?

Anyone witnessed this before?

SQL> select * from dual;

ADDR INDX INST_ID D
-------- ---------- ---------- -
03A00074 0 1 X

SQL> desc dual
Name Null? Type
----------------------------------------- -------- -----------
DUMMY VARCHAR2(1)

SQL> select * from dual;

D
-
X

SQL>

Happened during startup of the instance. 10GR2 EE on MS Win XP.
at

1 comment:

  1. Anonymous12/07/2011 12:22 PM

    Hi Frank:

    Kind of old issue.

    You can find more about it here:

    http://blog.tanelpoder.com/2008/07/14/closed-database-and-with-subquery/

    Cheers.

    carlos.

    ReplyDelete