Re: indexes?

From: Michael S. Abbey <masint_at_istar.ca>
Date: 1998/03/22
Message-ID: <3515825a.3896042@news.istar.ca>#1/1

On Sun, 22 Mar 1998 14:26:33 -0500, Peter Chan <chanp_at_nortel.ca> wrote:

>Could I create an index for a table that is in use? That is there is
>someone updating/inserting/deleting at the moment.
Most of the time (and just my saying that will probably put the success of your statement in jeopardy) YES.
>
>Or do I have to stop all transactions on that table before creating the
>index?

Not at all.

Michael

+------------------------------------
+  Michael S. Abbey    Ottawa Canada
+  Co-author of Oracle8: A Beginner's Guide

+ and 5 other works in the Oracle Press Series

+------------------------------------

Received on Sun Mar 22 1998 - 00:00:00 CST