Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sys.dual? index?

sys.dual? index?

From: lfree <a_at_a.a>
Date: Sat, 11 Mar 2006 09:21:08 +0800
Message-ID: <dut8qg$h5l$1@news.yaako.com>


select * from v$version

BANNER



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

5 rows selected.

I create a index at sys.dual,

CREATE INDEX I_DUAL_1 ON DUAL
(DUMMY) ; but I want to delete the index , hint :

 SQL> DROP INDEX "SYS"."I_DUAL_1"
ORA-00600: internal error code, arguments: [12830], [SYS], [DUAL], [], [], [], [], []

Why?

thank advanced . Received on Fri Mar 10 2006 - 19:21:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US