Re: sys.dual? index?

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?
>
> thank advanced .

To create the index you must be connected as SYS, so why on earth are you trying to drop the index with "OWNER"."INDEX_NAME"? Not that it shouldn't work, mind you, but one usually doesn't include the connected username when dropping objects as that user. A simple:

SQL> drop index i_dual_1;

should work just fine. And, as noted by hpuxrac in a somewhat indirect fashion, 8.1.7.0.0 isn't the most robust or bug-free release of 8.1.7; you should be patched to 8.1.7.4. (You really *should* be up to at least 9.2.0.4, but there may be application issues we know nothing of which would prevent that.) You've probably run up against a known bug for 8.1.7 and a patch to correct it may already have been released, a patch you've yet to apply. I'd be perusing Metalink for such information.

David Fitzjarrell Received on Fri Mar 10 2006 - 20:38:20 CST