Have you tried using the UNRECOVERABLE option? This will definitely speed it
up. The only drawback is that if your database crashes before the next full
backup, the index will not be recovered and you will have to recreate it.
rtgraf_at_my-dejanews.com wrote in message <6pklq9$orh$1_at_nnrp1.dejanews.com>...
>In article <6pjpm5$qi3$1_at_nnrp1.dejanews.com>,
> gplagge_at_hotmail.com wrote:
>> 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.
>If your system is *completely* quiet, check out
>v$rollstat if there is still write activity on
>the rollback segments.
>Also, check your ALERT.LOG for messages like
>'could not acquire new log, archival required'.
>Maybe you are running in ARCHIVELOG mode with
>automatic archival *not* enabled.
>(Check out the command
>archive log list).
>--
>Robert Graf-Waczenski e-mail: rtgraf_at_sintec.de
>Visit our web site! http://www.sintec.de
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Jul 30 1998 - 04:05:39 CDT
