Re: sys.dual? index?

From: glumtail <glumtail_at_gmail.com>
Date: 12 Mar 2006 03:38:52 -0800
Message-ID: <1142163532.600463.131670@z34g2000cwc.googlegroups.com>

Hi lfree:

I think it is not a bug.

GLUMTAIL_at_TESTDB> select * from v$version;

BANNER

---

Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production PL/SQL Release 8.1.7.1.0 - Production
CORE 8.1.7.0.0 Production
TNS for 32-bit Windows: Version 8.1.7.1.0 - Production NLSRTL Version 3.4.1.0.0 - Production

GLUMTAIL_at_TESTDB> create index gt_dual_index on dual(dummy);

Index created.

GLUMTAIL_at_TESTDB> drop index gt_dual_index;

Index dropped. Received on Sun Mar 12 2006 - 05:38:52 CST