Re: wierd locking issue

From: Kurt Franke <Kurt-Franke@xxxxxx>
To: oracle-l@xxxxxxxxxxxxx, ryan_gaffuri@xxxxxxxxxxx
Date: Tue, 26 Feb 2008 12:32:12 +0100

you may issue a

LOCK TABLE your_table IN EXCLUSIV MODE;

just before the ALTER TABLE ... ADD/SPLIT/DROP PARTITION ...

in your code to force a wait.

> I have code that adds and drops partitions. I am constantly getting this 
> error. I am doing a few things to track this down and alleviate it. 
> 
> 1. at the beginning of the execution of my package I issue:
> alter session set ddl_wait_for_locks=true;
> 
> now I thought that with this set to true, I would just wait when adding or 
> dropping a partition instead of erroring out?
> 

regards

kf


--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: wierd locking issue
From: Powell, Mark D

Re: wierd locking issue

Other related posts: