I am trying to do a TRUNCATE TABLE My_Table but keep getting this error;
A self-deadlock among DDL and parse locks
is detected. In most cases, this self-deadlock
is handled internally.
This should be reported to Oracle Support
ONLY IF an error is signalled back to the
user on a command-line or
Does it have foreign keys?
Farnsworth, Dave wrote:
I am trying to do a TRUNCATE TABLE My_Table but keep getting this error;
A self-deadlock among DDL and parse locks
is detected. In most cases, this self-deadlock
is handled internally.
This should be reported to Oracle Support
ONLY IF
Hey Dave,
Are you issuing this thru SQL*Plus or Server Manager? Or another package
like TOAD, that could be issuing some background queries'n'things that may
be locking the table on you?
Since this is a test system, I wonder what kinf of trace you'd get by
setting event 4020?
Rich
Rich Jesse
I am trying to do a TRUNCATE TABLE My_Table but
keep getting this error;
A self-deadlock among DDL and parse locks
is detected. In most cases, this self-deadlock
is handled internally.
This should be reported to Oracle Support
ONLY IF an error is signalled back to the
user on a command-line or
I'm having a blonde moment. It was a permissions issue. The table was in a different
users schema. DUH.
Dave
-Original Message-
Sent: Monday, March 10, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
Does it have foreign keys?
Farnsworth, Dave wrote:
I am trying to do a
If you want to pin down why the deadlock is occurring,
Here's an approach that Stefane Faroult suggested to
me a couple of years ago.
Connect as sys, and create a pair of DDL triggers
that log the contents of x$kgllk and x$kglpn before
and after truncate - then reconnect as the relevant
user and
Title: RE: I am an idiot - WAS -deadlock problem
go girls... fire the shots at'em :-)
-Original Message-
From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 10, 2003 12:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: I am an idiot - WAS -deadlock