Unable to drop index :(

From: steve perry <sperry_at_sprynet.com>
Date: 21 Feb 2002 08:07:45 -0800
Message-ID: <27bc2d9d.0202210807.5118da0f@posting.google.com>

Oracle 8.1.7 EE
OS: nt 4 svc pack 6

I have a test index that I created as

CREATE INDEX test_IDX1 ON PARTITIONED_COMPANY (STATE_OF_INCORPORATION_CODE)
NOLOGGING LOCAL(

     PARTITION test_PART1   TABLESPACE  BMCS_IDX_PART1 NOLOGGING    


   , PARTITION test_PART2   TABLESPACE  BMCS_IDX_PART2 NOLOGGING

, PARTITION test_PART3 TABLESPACE BMCS_IDX_PART3 NOLOGGING
, PARTITION test_PART4 TABLESPACE BMCS_IDX_PART4 NOLOGGING )
/

when I go to drop it, I get

DROP INDEX test_IDX1
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

Are there any "hidden" ways to force it drop??? I thought about running a trace and deleting from the sys tables, but I only as a last resort before going to an old backup.

I checked metalink, but didn't see anything there to help.

Thanks,
Steve Received on Thu Feb 21 2002 - 10:07:45 CST