Re: mysterious share table lock

From: Fred Petillot <fpetillo_at_fr.oracle.com>
Date: Thu, 13 Jan 2000 10:56:22 -0100
Message-ID: <387DBD65.C67DDBF1@fr.oracle.com>

Benjamin Toronto wrote:

> Amazing; it worked. As you may have guessed, I am not an Oracle DBA,
> just a lowly application developer, but I would like to know WHY inexing
> the foreign key solves the problem. Is it because the delete statement,
> without an index, performs an implicit full table scan, thus requiring a
> share table lock? Is there any Oracle documentation on this?

Application Developer Guide 7.3 ch 6 pp 10-12 Application Developer Guide 8.0 ch 9 pp 10-12

+-------------------------------------+----------------------------+
| Fred Petillot                       |     fpetillo_at_fr.oracle.com |
| Oracle France - Support Technique   |            +33 1 4762 8201 |
| 65, rue des Trois Fontanot          |            +33 6 8089 5135 |
| 92732 Nanterre Cedex                |                            |
+-------------------------------------+----------------------------+

Received on Thu Jan 13 2000 - 05:56:22 CST