Help!!! Index creation Error ORA-600

From: Raj <rajeev_goel_at_infy.com>
Date: 15 Jul 2001 23:18:26 -0700
Message-ID: <bc311178.0107152218.31e9c42d@posting.google.com>

Hi All,   

 We want to create indexes on a snapshot and our index creation script is:
CREATE INDEX mySnapshot_pk

        ON mySnapshot(
            Field1,
            Field2,
            Field3,
            Field4,
            Field5,
            Field6
        )
        TABLESPACE index_ts
        STORAGE (INITIAL 5m NEXT 5m PCTINCREASE 0);

CREATE INDEX mySnapshot_idx

    ON mySnapshot(

        Field1,
        Field2,
        Field5,
        Field6

    )
    TABLESPACE index_ts
    STORAGE (INITIAL 5m NEXT 5m PCTINCREASE 0);

 The first index is created. After that Oracle throws following error:

        ON mySnapshot(
           *

ERROR at line 2:
ORA-00600: internal error code, arguments: [6302], [2], [], [], [], [], [], []

Does anybody have any idea what this means?? Is there any workaround?? we need to have an index since the snapshot has about 2.8 milllion records. Oracle version is 8.1.6.0.0 running on SunOS 5.8.

Thanks in advance,
-rajeev Received on Mon Jul 16 2001 - 01:18:26 CDT