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.

1 comment:

Anonymous said...

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.