Alter index in Parallel Error

Hi there,

I'm having a problem with an index that I'm trying to rebuild (actually it's for a customer) they are getting the following error.

ALTER INDEX MACKAYS.WAR_PIK_BRN_TOT_WORK_X1 REBUILD NOLOGGING PARALLEL 5;
ALTER INDEX MACKAYS.WAR_PIK_BRN_TOT_WORK_X1 REBUILD NOLOGGING PARALLEL 5
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P003
ORA-00932: inconsistent datatypes

Any ideas of things I could try would be great.

A

First I would try connecting directly to the schema:

conn mackays/

ALTER INDEX WAR_PIK_BRN_TOT_WORK_X1 REBUILD NOLOGGING PARALLEL 5;

If this doesn't work then try 'dropping' the index and creating new:

create index MACKAYS.WAR_PIK_BRN_TOT_WORK_X1
on MACKAYS.WAR_PIK_BRN_TOT_WORK
(columns...)
unrecoverable parallel 5
..etc..

More info, I believe it's a known bug for the particular type of index that is being created.

It works fine serial.

The database is on Oracle 8.1.6 - it's fixed in 8.1.7

Thanks for your help anyway, love this forum!!

A