Re: ** Urgent: Help needed on create index ***

From: EnderW <ender29_at_my-deja.com>
Date: 2000/06/30
Message-ID: <8jj347$t5d$1@nnrp1.deja.com>#1/1

The table is composed of several rows. I am indexing on two rows. The structure similar to this

mytable
  id number(38)
  anotherid number(9)
  yetanotherid number(9)
  .... more fields

the command is

create index index_mytable on my_table
(
  anotherid desc,
  yetanotherid desc
)
nologging
parallel (degree default)
storage (initial 32M next 32M maxextents unlimited) /

Soon as I run it, I get the error. When I take off parallel, it disappears and later I can do alter index index_mytable parallel and see it is been set to default parallelism. Am I missing something ? Hopefully yes

In article <8jisne$o35$1_at_nnrp1.deja.com>,   ddf_dba_at_my-deja.com wrote:
> In article <8jisf6$np5$1_at_nnrp1.deja.com>,
> EnderW <ender29_at_my-deja.com> wrote:
> > Hi,
> > I am trying to create an index and I seem to be getting this error.
> > Any ideas to why ?
> >
> > ORA-12801: error signaled in parallel query server P002
> > ORA-00932: inconsistent datatypes
> >
> > parallel degree(default) is used in index creation
> >
> > --
> > Ender Wiggin
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >

>

> Without knowing the table structure or the actual 'create index'
> statement debugging this situation will be difficult. If you could
 post
> the table description and the create index statement it would be most
> helpful.

>

> --
> David Fitzjarrell
> Oracle Certified DBA

>

> Sent via Deja.com http://www.deja.com/
> Before you buy.

>

--
Ender Wiggin


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Fri Jun 30 2000 - 00:00:00 CDT