Re: Help!!! Index creation Error ORA-600

      1228658 This problem was introduced in 8.1.6.0 Create INDEX on a snapshot / MVIEW can produce a corrupt index. This may show up as ORA-600 [13004] or an ORA-600 [25012] or ANALYZE TABLE snapshot_name VALIDATE STRUCTURE CASCADE reporting ORA-1499. This can easily occur if the index can be built from an existing index on the snapshot.

--
Robert Fazio
Senior Technical Analyst
dbabob_at_yahoo.com

"Raj" <rajeev_goel_at_infy.com> wrote in message
news:bc311178.0107152218.31e9c42d_at_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