Alter index in Parallel Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Alter index in Parallel Error

  1. #1
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200

    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
    What's the sound of one hand clapping - "CL"

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,460
    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..

  3. #3
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    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
    What's the sound of one hand clapping - "CL"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width