Re: Deadlock error code

In article <8inuab$srb$1_at_bob.news.rcn.net>,   "Brandon Duncan" <bduncan_at_pietechnet.com> wrote:
> I can't seem to find the documentation for the actual number of the
 deadlock
> error code for ORACLE.
> In SQL Server, it's "A 1205".
> Thanks,
> Brandon
>
>

its ora-0060

you won't need it even a small fraction of a small percent of the number of times you needed it in the other database though ;)

(if you do get it, make sure to index your foreign keys and it'll pretty much probably go away -- see
http://osi.oracle.com/~tkyte/unindex/index.html for why this is so)

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.