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 -> Re: sys.dual? index?

Re: sys.dual? index?

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 10 Mar 2006 17:25:47 -0800
Message-ID: <1142040347.442307.65770@z34g2000cwc.googlegroups.com>

lfree wrote:
> 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?

8.1.7.0.0 ?

Why? Received on Fri Mar 10 2006 - 19:25:47 CST

Original text of this message

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