Re: sys.dual? index?

> 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;

I connect as sys, try 'drop index i_dual_1' , hint the error is same.

> 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.

thank you .

 it is a test system, I think this is a bug. I will be patched to 8.1.7.4.
btw : my colleague test at 9i,it is not occur . Received on Fri Mar 10 2006 - 21:07:33 CST