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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
