Index creation taking days

From: <gplagge_at_hotmail.com>
Date: Tue, 28 Jul 1998 06:04:53 GMT
Message-ID: <6pjpm5$qi3$1@nnrp1.dejanews.com>

Hi, we are running Oracle 8.0.4 in an NT 4.0 environment.

I am attempting to create an index (concatenated on 2 columns) on a table with 16 million rows. So far, it has been running for over 24 hours, and I have 4 more to build! I am using the norecover and parallel options

The system is very quiet other than the one create index command, and one select statement. Thanks for any help.

Gene Plagge
WorldxChange, Inc.
gplagge_at_hotmail.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 28 1998 - 01:04:53 CDT