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

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

I have tried to recreate your error using similar syntax on a test table in 8.1.5 and I cannot. Do you receive an error when querying this table after the index has been made parallel? I am at a loss as to the root cause of this problem.

--
David Fitzjarrell
Oracle Certified DBA


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