Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ** Please read urgent: Help needed on create index ***

** Please read urgent: Help needed on create index ***

From: EnderW <ender29_at_my-deja.com>
Date: 2000/07/10
Message-ID: <8kd6ha$31s$1@nnrp1.deja.com>#1/1

I am still waiting for an answer. Any clues ?

In article <8jj347$t5d$1_at_nnrp1.deja.com>,   EnderW <ender29_at_my-deja.com> wrote:
> 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.
>

--
Ender Wiggin


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Jul 10 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US