Re: Indexing problem

From: L120bj <l120bj_at_aol.com>
Date: 1997/03/11
Message-ID: <19970311212500.QAA14963@ladder01.news.aol.com>#1/1

Does the table you are creating the index on have a degree of parallelism
> 1 set (check the degree column of user_tables) ?. If so then you may be
experiencing the same parallel query bug we encountered on 7.3.2.2 of ORACLE at our site. There is a patch available from ORACLE so it may be worth ringing support to see if it's available on your platform. Hope this helps,
Rob

---

---

Subject: Indexing problem
From: Andy Hardy <aph_at_ahardy.demon.co.uk> Date: Tue, 11 Mar 1997 19:27:02 +0000
Message-ID: <XLwBmFAGIbJzEwPy_at_ahardy.demon.co.uk>

Hi,

I've being trying to add an index to a column in one of my tables.

The create command executes for a few minutes (it's a 4m row table, most values in the given column are null) before dumping me out to the system prompt.

There are no error messages displayed either on the screen or in the alert log.

Other indexes on the same table create fine.

Any ideas?

Andy

Andy Hardy. PGP key available on request

---

Anyone who is capable of getting themselves made President should on no account be allowed to do the job.

• Douglas Adams, "The Hitchhiker's Guide to the Galaxy"

Received on Tue Mar 11 1997 - 00:00:00 CST